Microsoft Access / VBA Forum

I have a query with calculated field NVB which contain both positive and negetive values. I want an expr that convert the negetive value to zero. Pls helf

Introduction The Advanced Encryption Standard is the algorithm that won the National Insitute of Standards and Technology's (NIST) search for a standardized encryption algorithm in 2001. In 2002, it was adopted by the U.S. government as a stadard for encryption. It is based on the Rijndael algorithm. Even though it was chosen by NIST, it was...

hello guys im a beginner in programming .. i have a problem in saving option in access... in access when you type information in fields it automatically save in database if you click the next button command even if you are not clicking the save button.. and i want is, the data will not be save if the save button command is not using.. (sorry...

this is my query and if i run the query it will be save the record in the query it self not in the table that i created im using ms access 2016 SELECT ledger.ID, ledger., ledger., ledger.Amount, (Select Amount From ledger Where ledger.ID = (Select Min(ID) From Ledger)) - Nz((Select Sum(T.Amount) From ledger...

I'VE done followed some thread on auto resizing a access form to fit current screen in vba for access forms but have no luck. I want the form to automatically resize to fit current screen. I dint know where to where to start, appreciate if any help.

Hello, Can you please help me to figure why is giving me this error: Syntax Error(Missing Operator) in query expression '()' What I am trying to do is when user clicks Save, the system will firstly remove all bank holidays in the holiday Flatfile table (for selected country) and replace with what's in the list (selected country). Thank you. ...

Hello, I have a access form that has a new button that opens a new record form that has all the fields in my table bound to textbox controls. I want to make sure that the user populates the ID field first before adding the record to the table. The table has this field already set as the primary key and indexed no duplicates. What is the best...

I am getting a compile error https://bytes.com/attachment.php?attachmentid=9496&stc=1&d=1529078872 I have tried decompiling, building a new Db. Other databases using outlook work perfectly. Anyone any ideas please

MS Access 2010. I am using a split form and when I perform a search for a record, and there are no duplicates, need to display that single record and not the other records in the table. If are two or more records (duplicates), need to display only those duplicates and not other records in the table.

I have a very simple table that has only four columns. 1) College 2) Department 3) Employee 4) Completed Date I have created a report using groups and totals. the College is the first level, the department is the next. I then ONLY want to know how many people are in each department, how many completed the training (I have succeeded this...

How to design a multilingual database in MS Access? My basic database is in English and now I have to show it in Urdu.

Hi all, I'm new to this forum. My Access skills are above basic, but I seem to be having trouble getting to the next level regardless of how much time I invest in it. I'm using Access 2016. Here's the current issue I'm working on. I have two forms. One called Frm_AddSku, the other called Frm_AddProdSubCat. I know that Access has a built...

Good Afternoon, I have been trying to figure this out for days. I have a search form in Access 2007 that is unbound with unbound text boxes. The submit button works great, but I am trying to creat a clear button so that the user can clear out their information at once instead of each individual field. My form name is SearchingForm and the...

Moderator: Split off from https://bytes.com/topic/access/insights/906850-aes-encryption-algorithm-vba-vbscript I am desperately searching for a routine to AES encrypt a password that is submitted in an access form as a string and then I will use DAO to write it to a linked SQL table. I have tried over and over to convert the example you gave...

Good day people! I am trying to do a Dlookup or any lookup option on my form. so I already have my form with a search option that works fine and get the date I want from my table. The problem is that I am trying to put a text box or what ever I should put so that box shows the info from another table. I know it doesn't sound clear put...

I've been through: Open → Load → Resize → Activate → Current but each of these seems to occur before the form is actually displayed on the screen. I even tried GotFocus. I have a msgbox that is supposed to display after the form is displayed, but it actually shows up before the form displays and stops it from being displayed until the...

I have recently, migrated all my table from ms access .mdb into SQL Server 2012. I have relinked all the tables successfully and can view the records. However, i am unable to write back into SQL Database from all my access forms. I have tried looking all treads here but none of them is helping. Appreciate any input and feedback. All my forms are...

It would be great if someone helps me out! I'm getting an error as "Syntax error (comma) in query expression" for the below code in MS ACCESS 2007. CurrentDb.Execute "INSERT INTO empmast(empno,empname,scale) SELECT (, , ) from TABLEA" Thanks in advance

If have a form with several controls on it, and a subform. When I use the control to choose date and strategy, and then hit a button, the query's sql adjusts properly, and the subform requeries great, and all is well. BUT... When I select an option group instead, the query's sql DOES update properly, but the subform does not requery. I can't...

I have created Access 2016 Database with custom Icon. I can’t figure out what I am doing wrong. Here is the problem: When I tested the database in my developing Computer, it opens with my custom Icon and everything is great as expected. But when I move it to another computer that does not have Access 2016 installed and run my Database in Run-time...

I have problem with my append query I have a query Name NewData with exist in a temporary and i have created an Append query name Appenddata. When i run this query i would like the data from temporary table to be inserted into dbo_Master table which reside in MS SQL server. However when i run the appenddata query in is appending zero data into...

Hello everyone! I´m quite new with Access and I´m not able to understand if what I have in mind can be done with Access or not. Let me explain: my aim is to create a database of landslides where each landslide is described by different parameters. So in the table of "LANDSLIDE 1" I´ll have all the information about this landslide (location,...

I am a newbe Access 2010 'person' and have designed a simple membership record database consisting of a main and subform. I want to print a membership handbook with a page for each member. I Created a report consisting of data from the main and subtables and although I can see all the data i cannot get the report to page break after each member...

I need some help folks. I am trying to extract the first name space last name from an email address containing first name dot last name. I was able to complete a work around to extract first name. Then I am to extract the last name but not "subtract" the "@Domain.com from last name portion of the string. I know there is a way to perform this...

I want to import excel spread sheet into access 2007 using DoCmd, TransferSpreadsheet command. But how can I specify if I want to import selected columns instead of a particular range. Please solve it