Search results

Pat, thanks for the tip! I got it to work by doing what you suggested. I just wanted to say thank you to everyone who has helped me out with this problem by posting on this thread. I sincerely appreciate the time and effort each of you has put in to helping out someone, (read: me), with less...

tonyb, Before your code to launch the query put in this code: DoCmd.SetWarnings False Then after your code and before the end sub put in: DoCmd.SetWarnings True So the end product will look something like this: Private Sub MAke_table DoCmd.SetWarnings False DoCmd.Open your query...

Pat and R.Hicks, Thanks for the replys I really appreciate it. I think you both are talking about the same idea with the dummy table with two records. My problem is that I don't have the report being generated through a query but instead have it linked through the record sources by the SELECT...

Opengrave, Quote: __________________________________________________________ My own security – that was why I asked what you are using __________________________________________________________ I was hoping you wouldn't say that! As far as the =CurrentUser() func. I use this a couple times...

Opengrave, Thanks for the reply - The "built-in" security I mentioned in my initial post is the Access Workgroup Security created by the wizard. Question: - The code that you have posted, does that reference groups for Access Workgroup Security or is that set for your own personal designed...

Thanks to everyone for the replys but I still haven't found the solution. Pat, in regards to your suggestion of using the label wizard to create the report, the problem I have run inon is that the report is generated by the SELECT DISTRINCT ROW funciton so that it only pulls the current...

Hello everyone! I am using A'97 and have built in user-level security, my question is this: Is it possible to reference a security group account for a particular function in code? For example: - I have a form that has a command button to go into previous records, (The default I set was that...

Ian, Thanks for the reply. I can't do this because of the headers and groups like you stated. As far as breaking up the page first... I currently have the users doing this until I figure out a solution to get the report to print twice on the same page. This is a problem because the computer...

Question for the masses: I have a report that is exactly 1/2 of a normal 8.5 by 11 sheet of paper. What I want to do is have the report print itself twice on each sheet of paper. The group I am building this database for have a receipt report that has to print 2 copies (1 for record-keeping...

Question for the masses, I have a cmd buton that runs a delete current record operation. I have the code set up so that when pressed, an input box tells the user that the supervisor must enter his/her password to complete the function. The code is listed as follows: Private Sub...

foolishone, Not a problem, I will gladly post the answer that Charityg created for me. (I hope this works as well for you as it did for me ) Private Sub custmcID_AfterUpdate() Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("customers", dbOpenDynaset)...

Charity, I case my last e-mail did not reach you, (because of e-mail problems), I just want to thank you again for your help with my db. Taking the time out of your day to help me was great and I really appreciate it... Again... thanks, Kevin

I really appreciate it Charityg, I'm sending over the db now.... Again, thanks Kevin

Good morning all, If someone could help me out on this I would really appreciate it. I have posted this question a few times in the past and many people have jumped in to help but unfortunitly non of the help I have recieved in the past has worked. Anyway, enough with my begging, here goes...

Question for the masses: Does anyone know if there are different formats for currency in A'97? I checked the help files but found nothing... Thanks in advance, Kevin

GregM, Generally, as Rich pointed out its not a good idea to store calculated values in a table... However, that being said, if you feel you must do this try adding your bound fields to your form and setting their visibility control to no. Then in the afterupdate event on your calc. field set...

kwatai, I'm a little confused on what your trying to do... Are you saying that if the amount is in Amreican you want to be able to view it in Canadian, and if the amount is in Canadian you want o be able to revert it back to American currency for storage in your table?

russi, I didn't want to e-mail you directly until I got your permission to do so, but could you possibly send me a copy of the sample database that can adjust screen resolutions? I have seen the previous thread on this topic but have never gotten a response to my post. Thank you in advance...

HJAMES, We are almost there!!! I have the code for the message box located in the 'On Load' event procedure on my switchboard form. The message box code runs when the form is loaded for the first time. I have placed the checkbox control on the bottom of the switchboard form and labeled it...

John S, Try putting the code in the 'OnChange' event, that should take care of your problem... HTH, Kevin