Search results

How do you do an Access/VBE split screen? I want to be able to watch the code execute as I enter data into the form. I have redesigned a database, essentially building a new one from scratch. I have all of the forms created and they are working beautifully. :) Now, I'm error-handling to...

I have a public function in a standard module that adds records to a table. The function returns a comma-delimited list of the batch numbers that it added to the table including leading and trailing commas. I am trying to run a query using the list to select just those records that are in...

I have a sub routine that add news records to an AssignedBatches table based on criteria in a function. The function returns a variable length array of batch numbers that are to used in assigning batches. I've got this part working well. Now I need to show the user the added records. My...

I'm working on a main form to assign batch numbers used to process transactions. Based on the type of transaction needed, the first character of the batch number varies. There are about 15 rules. I'm trying to formulate a plan for this and here's what I've got. Create an outer join query...

Hello! I've redesigned a db for my work. The purpose of the db to assign and keep track of assigned "batch" numbers. The current db stores all the info in one table: batchnum, username, managername, dept, employeeid, location, typeofbatch It's a wiley beast with over 200,000 records...