Recent content by Sharontha

I have a reoprt that prints over a 1000 pages in total. this is done through a module.The problem problem is because in those 1000 pages it prints about 80 total reports(same report broken down to 80 seperate people) and everytime it's done with one report there is a pop up that promps me(same...

Thanks much guys!

why do i get the databse SAVE pop up when i run the compact database command in a macro? is there any way i can get around this? Any help would be greatly appreciated.

Ken, Thank's much for your help!!

Hi Rich, The data which is used in this database is pulled out from out network tables and the tables which the data is pulled out from is linked. Everytime i click the update macro it makes tables using the linked tables for the purpose of analysis. This has to be done almost every other...

I have a database that i am building for one of our stores and it has to be updated 2 or 3 times a day. Is it possibe for me to create a process to update this databse for example every morning at 6AM without creating an update macro that has to be clicked? Please remember i'm new to access so...

Eureka!! it worked ! David thanx a lot for your help!!

The below is what i have but it's giving me the following msg ( compile error: Else without if) why is that? Private Sub Run_Reports_Click() On Error GoTo Err_Run_Reports_Click Dim stDocName As String stDocName = "If IsNull(Me.Combo4) Then" MsgBox "You must select a report...

Thank Very Much David. Let me try and i'll get back to you if i have any problems.

I have about 20 reports in my database. Rather than me putting 20 buttons, Can i have a combo box where the user can select the report that he/she would like to run? If any of you guys can lead me in the right direction regarding this i would greatly appreciate it....FYI i'm new at access ;)...

Paul Thanks for all your help. I'll get back if i still have a problem, with it.

Paul, like Harry was saying teh number could be 23.23 but if the number is 1.1 would this still show correctly? Again i like to thank both you gentlemen for your time.

Harry, Thanx for your help . I'm sorry i wasn't too clear on my post. It does not have to be zero's that follow or precede it can be any value as long as it 16 in total.

I'm pretty new in Access and I thought i was good after my 1 year of experiance untill i saw how far advanced all you guys are. Anyway this is my question: I have a query field that i want the numbers that i load into the table to show a set number of valuesin front or after the decimal point...