Recent content by MSUKevin

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