Search results

Here it is with combo box added.:)

Just opened it up and I do see that, i do apologize. I could add one then re-upload.

any ideas so far?

Here is a stripped down version of what we have. It only has one generic record and form. Thanks for the encouragement!!

Hmm...I think I'm just getting in over my head on this. I'm quite new to Access, so maybe I should just keep tinkering on hahaha. I can't seem to get this to work out for me. Thanks anyway guys :)

Yes there is. I made sure to copy the columns name and paste it in just to be safe and not put a cap where there shouldn't be lol.

Did that, same error lol. I realized that after I made the screen cap that those needed changing.

I get that error.

Form Name: EmpDoc Combo Box: empID Fields to populate (for now): Emp_LName, Emp_FName As far as the SQL, all I see is "Row Source: SELECT [EmpTable].[AgentID] FROM [EmpTable]". Hope that helps :confused::confused:

Thanks for the tips, but I just can't seem to grasp this whole thing. max, when I tried it your way, i couldn't choose any record besides the first. And Alc, I tried that with no success as well. Thanks for the quick response though, +rep

Hi again! My new dilemma is such: I have a table of about 16,000 records, each one being an employee. In order to fill out their daily forms, they currently have to manually type in all of their information (name, department so on...). With this table already populated with the basics, is...

Got it working, thanks for all the help!!!

I get where you are going with the message boxes, but I'd like to keep as little interaction as possible with the database. I've tried everything I could think of to subtract 2 days from today's date in code. I appreciate the effort though, thanks! :)

Yes, exactly. I have a function that downloads a file from Friday, but I can't run it until Monday. The file that is downloaded needs to have Fridays date at the end of it, which we're doing manually. Since everything up to that point (which is the final step) is automated, I'd like to...

So I have the following code to save a file with today's date, but can that be changed to save with yesterday's date or even the date from 2 days ago? Just wondering because I have a task that requires saving a file name with Friday's date when you run it on Monday...

You guys are awesome! Thanks a lot! My database looks great!

Basically, I just want to make a progress meter that updates after all 4 of the following steps are done. I run a macro, then batch file, then 2 more macros. Since this process in total takes up to about 30 minutes, a progress bar would be great. I did a search and everything i found was...

Ah, there's my problem then! hahaha, I'm terrible with code, hence using macros. Thanks a lot for the quick response!

That was a suggestion by a co-worker here, but I'm running my batch files via macro through the RunApp option. How would shell&wait work with that?

Hi all, what I am trying to do is automate a task I have. Instead of being able to have it all run off of one button click, I have to click the first, allow the batch file we use to finish, then click the next button. If I can get Access to pause while the batch is running, then continue once...