Recent content by pcast01

Sure no problem... Good Luck! :-) CHAOS, PANIC, & DISORDER - my work here is done.

Hello testeng, Also the correct you should run is appAccess.Run "Function" The other code brings back the error: The command or action 'Run' isn't available now. Just some FYI... CHAOS, PANIC, & DISORDER - my work here is done.

I think I know what you mean... You have an AfterUpdate code that sets those values in hte text boxes after you select a value in the combo box. Now you are saying that whatever value is put into the FHA text box will determine what is put in other fields. Is that correct? CHAOS, PANIC, &...

Yes that is normal. The table won't be available till after adding the field. CHAOS, PANIC, & DISORDER - my work here is done.

Does this new code work?! CHAOS, PANIC, & DISORDER - my work here is done.

I recreated your issue with one of my tables and was able to get consistent results. I created a function on the search dialog and used it on a number field and a string field. I would do the first search with a button then I put the find next on the toolbar and would click on it to scroll...

Hello Tinapa, I think the problem is the writethis in your code. Also I would suggest possibly using IIF function. Syntax is IIF(statement, true, false). CHAOS, PANIC, & DISORDER - my work here is done.

Ace is right DajTwo... Does your form have a Record Source? If so you can just use that. I would suggest making the record source the table that you are modifying. As far as the combo box you must set the exact column of the value that you want to save in the new record. For example: If the...

DajTwo, All that code does is find the record based on the combo box value. I have a way to do what you were asking for but I am sure there is a better way to do this... This is only assuming that the Form is bound to the table that you want. Basically what I do is save all the values...

Hello gkaher, I found this online, it should be able to point you in the right direction! Age-Based-File-Deletion CHAOS, PANIC, & DISORDER - my work here is done. I currently use Access 2003.

Hello DajTwo, There are a few different ways to do this. First of all, What version of MS Access are you using? If you are using 2003 and lower then I might be able to help you. I know nothing about MS Access 2007... Have you created a form? If so you can the Record Source equal to the...

I also had that same error when importing Excel files. I had a workaround where I would have the excel file open and then that error would disappear. Since then I have changed file format. I change the Excel sheet to CSV file format then import using TransferText. It works better to import...

I figured it out. I used DoEvents function and it seemed to help me out. My form now comes up while the forms open in the background. Thanks! CHAOS, PANIC, & DISORDER - my work here is done. I currently use Access 2003.

Hello all [smile], I have a question that maybe someone here can help me out with. I have a Splash screen form that i have open on startup and then use the Timer to close the form and open the main menu. I have gotten that. But I want to open a Form hidden while the Splash Screen is open. I...

Thanks again tsuji. I got it all figured out. You were the biggest help. CHAOS, PANIC, & DISORDER - my work here is done.