Search results

I found some code to check if all the fields in a form are complete, and if not, highlight and not allow Save until all fields are complete. The issue I'm having is with another piece of code from Allen Browne (ajbFindAsUType) that finds records as you type. The code that checks for the...

I have an Excel spreadsheet that doesn't have any type of index, so I add one after the import. I don't understand why Import routine #1 doesn't bring in *all* the data, only some of it. I looked over the spreadsheet dozens of times but can't see why (I'd include it but it's confidential...

I have a db with 2 tables. Main table has ID (autonum, primary), Last, First, Email, Folder 2nd table has ID(number) Last, First, Folder I have set ID as the relationship between both tables (one to many). I just noticed the ID on the second table has no number in any of those records. I...

Please forgive my somewhat "sloppy" coding as I'm not too good at it as you might see. I've got an issue with retrieving random records which is puzzling me. When i run the code below, it only pulls 1/2 of the total # in the select statement SELECT TOP 10 * FROM SM_Import ORDER BY...

First off, I'm a complete novice with VBA. I'm using Access 2010. I have a database that during the import of Excel data, it brings up a dialog box, "Minor loss of Fidelity." I've searched high and low but have found nothing to dismiss that box using VBA. Reg hacks have been tried...

I have some code to send an email from Access however in the .HTMLbody, I would like to have part of the .HTMLbody set to a variable because at the beginning of every month, there is a URL within the body that changes. Can anyone help me on setting a variable for the URL as well as how to...

I have the following code which successfully opens the dialog box with filters however when I add a function to help with an Excel import, the filters do not work at all (no files are shown even though they exist in the directory that's opened within the dialog box). If I manually type in the...

I am a complete novice at scripting so please bear with me... ;-) I have a query that randomly selects records from my table: SELECT TOP 6 * FROM SM_Import ORDER BY rnd(INT(NOW*id)-NOW*id); I would like to loop through those results, and create emails I can get one email formed (displayed)...

I need some help with VBA code to first generate a random number between 1-4. Then I would like to use that number to pull that many records out of the database; the records pulled can be random, or whatever. For example, we have 4 people and my goal is to choose a random # of records to pull...

I have HTML files that end in with the extension .xls They do not have field names in the first row. When you attempt to open one in Excel, it coughs a bit with an error and then opens them (since they're HTML). I can then save the spreadsheet, then import w/o issue into Access. But I don't...

I have table1 in my (Access 2010) database that has exising records. I have another table2 that after I run a query, it first deletes the data in table 2, then imports new records into that table. I run the import into table 2 on a semi regular basis but have yet to copy those records into table...

Microsoft has a Desktop Student Database template (Access 2010) that does exactly what I'm trying to do: open the Outlook Contacts dialog box, select a contact from the GAL, and then programmatically save it to a record in one of my tables. I've tried simulating the button/coding on my data...

I have a very simple 2010 Access database with only one table which contains a few fields (username, email, phone....) I have a combobox with unbound controls to search/find users (by the lastname field). The combobox is in the header section which populates the fields (controls?) in subform...

I'm pretty new to Access (2010), and programming wise, very new and wet behind the ears so to speak !:o