Find your MS Access answers here and save on IT support.
Questions
Uploading text file in VBA to website
Comments: 3
I used GUIs for testing access to my website but now need a "silent" method that works in Win7, preferably for FREE. Is there a procedure to upload a text file within 2007/2010 Access usin...
Loop through two tables full of numbers to find matches
Comments: 12
So I am setting up this lottery DB. You select 6 numbers to start, you then enter the actual weekly lottery numbers and cross off the numbers you have selected that match the actual lottery numbers. It...
Check textbox validation between forms? Need someon to …
Comments: 3
Hello experts, I have two forms. And I need to check from FormA if fields are not empty in FormB. I have wrote this code, but it does not return results as it should. I think this...
Initial Size of File Dialog Box
Comments: 26
This code is now working beautifully, but when the dialog is first used after the application is started it is always opened at the smallest size possible and in the top left hand corner. It can be moved and ...
microsoft access form vba code to move the cursor to next…
Comments: 16
is there a way to use vba code to move the cursor to next record after the user presses the enter key only for my one particular form. I know you can set this at the database level, but that would prob...
Requery/Refreshing SubForm from Different Form/Subform
Comments: 2
I have a Form that has two subforms on it: Form: frm-Companies Subform1: sfrm-Company_Calendars Subform2: sfrm-Payroll_Dates_To_Exclude The two subforms are lin...
Need Access vba function to convert inches to feet and inc…
Comments: 9
Per the following code, I'm trying to take a numeric value and convert it to a string that displays feet and inches using Access VBA code? Could someone please take a try because most examples via ...
microsoft access query to convert a text string to a particul…
Comments: 4
I have a query that shows the field name [MODIFIED_DATE] in the following format as examples: 11 Mar 2005 17:46:39 08 Nov 2010 09:37:56 I need help in...
File Open diialog Box using VBA in Microsoft Access
Comments: 14
I use the function at the bottom of this question across our different applications and across Access 2000 to Access 2010. Function works fine, but my question is, is there any way to make it o...
auto back-spacing and other auto-texting if I wait too long…
Comments: 12
It seems when I am free-typing VBA that if I wait more than a couple of seconds to type, that Access is doing things like backspacing, adding the second quotation mark, and stopping the autofill on m...
Setting a combo box value based on another combo box sel…
Comments: 5
Desired Process: 1.The person selects their name in the combo "Originator" 2. Look in t.People to see if there is a numeric Account Number ID for this person (using the function below)...
vba sql syntax help
Comments: 3
The code below works great.................Now I would like help to substitute the hard coded dates with variable dates that will be passed via a form called "z filter" with the start da...
vba coding to extract specific information from a field in an …
Comments: 23
I have a table called iitdata with a field called "Comments" that is a memo data type field. This table has a primary indexed field called IITReportNo (no duplicates). This field has all kinds of informatio...
Array Concatenate
Comments: 23
Hello Experts, I'm having real difficulty trying to figure out how get an array to concatenate values in my data. This is the data I have: (TBL_Data) Name Successor_To Emp_...
Click on a name to email that person on a continuous form?
Comments: 4
SHORT VERSION OF QUESTION: How to click on a name on a continuous form then use that person's username (from a pre-existing table) to create an email to that person. ------...
Query won't let me write data
Comments: 3
This is driving me crazy on a query. I have three tables. 1) Study 2) Research 3) Scope Attached is a picture of the relationship and below is the SQL query. The Study is ...
Loop, array and concatenate
Comments: 9
Hi Experts, help!! I've got a data-set that I need to transpose and append into an access table. I haven't been able to figure out how this would be done. I've attached an example which ...
Update data-set for dual role
Comments: 12
Hello experts, I need help to update a data-set based upon a dual role. It's a bit tricky to explain so I've attached an example that should show my dilema. Thanks for any help or sugg...
Simulate AfterUpdate event with VBA
Comments: 2
I have a form with a combobox that when the user selects an item from the list it runs some code to populate the rest of the form for them. However, I sometimes pass the value of that combobox from a...
How do I programmatically attach all .dbf files in a folder to…
Comments: 3
I have 30+ dbf files in a folder which I need to link (not import) into my access database programmatically (VBA). How Do I do that?
PULLING MY HAIR OUT.... Recordsets, Looping....
Comments: 14
I am have a form (frmA) that has several records based on qryA. Each record (row) in the form has several fields. The fields of interest are a command button (cmdCheck), a checkbox (c...
Use hyperlink address as attachment path
Comments: 4
I am trying to use the hyperlink address as my attachment path, but can't quite figure out how to do it. It works great when I manually type in the path "C:\mydocument.txt", but that value will ch...
removing some spaces in string
Comments: 4
I have a string and i would like to leave spaces in between characters but only have one space so: the dog was very large indeed becomes: the dog was very large indeed ...
ELookup and Tables versus Recordsets
Comments: 4
I have a table of dates, identifiers and prices. I want to look up a specific price for a specfic identifier for a specific date. I thought that I would first separate out the information for the date I need usin...
How to create an Undo command button.
Comments: 14
I would like to add a cmdUndo to my form. I would like it to emulate the effect of the user hitting the ESC key; eg., - When a user is entering data into a field of a new record: hit Esc once to clear...