Search results

Hello, I have an Access 2007 (2010) database on my XP machine - 32 bit. The database creates other databases by taking data grouped by a union (a union can have multiple entities within it) and creates 1 database with that union and its multiple entities. A co-worker has Access 2010 with...

Hello, I am stumped and need some guidance. Have a table (br_stat_edits) which has sql statements in a field. Those statements are related to edit checks and I am trying to figure out how they are running in the code module. I've pasted the code below and am hoping someone can help me...

Hello Everyone, I'm trying to concatenate a form field - course category - when the course name and course id are the same but the course has two or more course categories associated with it. I found Allen Browne's concatenation function and I don't understand it, so can't figure out how to...

Hello All, I'm still trying to figure out my unzip files code that doesn't want to work. Am not sure if the "file exists error" is gone because I can't get that far into the code. Now the problem is I am getting run time error 91 "Object variable or With block variable not set" on the unzip...

Hello Folks! I'm having a difficult time figuring out what's happening with code to unzip files from a zipped folder. The code worked a month ago (unzipped the files, put them in the FilesforDOE folder AND the data was imported into the backend database) and now it doesn't do any of that! I...

Hello, I'm about ready to rip my hair out. I've been trying to run a SQL statement to select all the values on a form where the checkbox value is true. The form is designed to run edit checks on entities (which I'm also having trouble with getting only one entity's records to be reviewed at a...

Hello Everyone, Have been searching the site trying to find an answer to my problem and have tried some of the things I've found but so far - no luck. I've got files in an Access database that are to be saved into a folder in a directory and each file needs to have the date/time of import on...

Here I am again with my problem du jour! I'm trying to select all records in a table where an educator ID is = to an exact value but the courseid numbers are between two values. I've tried multiple ways to reference the numbers (with and without ", &, and values with () ) and I keep getting a...

Hi, I've been searching to see if I can find a solution to the problem I'm having - so far I haven't so will take a chance and post my question. I'm trying to import Excel spreadsheets into an Access database and I keep getting an error on the DoCmd line where it's creating the spreadsheet in...

Hello, I searched the site and couldn't seem to find a reference to the issue I'm dealing with. Am having a tough time getting an If Then statement to run properly. Am trying to find if an exact value is in a table and if it is not then the table needs to be updated to that new value. My code...

Hi! I'm relatively new to the programming world and definitely need some help. Am working on an application and trying to call a recordset to compare data that was entered into a form to data that is in a table making sure the "new" entry won't be a duplicate of what's already in the table. I...