Recent content by spencern

Hi everyone, I have a report that is printing out to a label printer. The only problem is, the label printer is only used for this application and shouldn't be set as the windows default. Is there anyway to change the printer in the print dialog only when the report is run, and then set it back...

Thanks Akribie I was wondering if that was the case, but still hadn't tried it out to see if you had to reimport everything. This should save some time later... Thanks again

Hi there, I had this problem a few weeks ago before making my vacation video and couldn't find the answer easily... But here it is: You need to uncheck 'Scale clips to project diemsions' under General project settings. You may have to re-import the images once you do this so it doesn't scale...

Thanks I'll take a look at the database and see which solution I can fit into it. Thanks again, Spencer

Hi, I'm investigating the purchase of a thermal label printer to use with an access app to print labels. Every time a label is printed, there needs to be 3-5 copies of the label. I'm thinking that the best way to print would be to setup a report with a single label in access and then change the...

Hello, I've got a page that I'm trying to print out the current Pacific time on but I've run into problems because my server is based in england and is 8 hours off. Does anyone know if there is anything I could do to my code to make it adjust to -8 hours of what the server's time is...

Hello, I'm working on a pharmacy db and can't figure out how to print a report based on which record is selected in a subform. Basically I have a subform that shows refills. I want to be able to right click a row in the subform, select print and have it print out a sheet of 10 labels. I think I...

Thanks for the link Bill, very helpful... I ended up using Forms!Mainform!Subform1.Form!ControlName and it seems to work fine. Thanks again for your help, Spencer

Hello, I have a main form add_customers that has a subform Equipment_Subform1. One of the fields in the subform is a combo box that gets its data from another table. I have a button to open a form to add entries to the table that the combo box gets its data from. After I add entries I want to...

Yes that makes a lot more sense, don't want to have to reselect 75 records after the paper jams...I tried on a second button and it works, Thanks again. Spencer

Thanks Bill, the query to update works great! Just one question about the code to run it though. Where should I put it? I have a command button that is printing the report. I used the access wizard to make that button and I tried putting your code underneath but it wouldn't work. Is this where I...

Hello, I'm working on a db that has a large list of customers in it. I am trying to figure out the best way of printing address labels only for selected customers. This is what I am thinking of doing, maybe someone else has done this and knows a better way... Every customer record has a field...

Thanks luceze, I put the following code in the on close event in the code builder: forms!Add/Edit Customers!Combo89.requery It doesn't like the form name and it doesn't work when I put quotes around the form name either. It says expected: = Just to make sure I'm on the right page, I should be...

Hello, I'm working on a db that is medical related and I'm having a hard time figuring out how to update a combo box on a form. On the add patient form is a combo box showing doctor names. You select the patients doctor from the list. If the doctor is not in the list I have an add doctor button...

Hello, I'm making a form that stores some information about people including gender into a table. I'm not quite sure how I should make the selection of gender on the form though. If I use an option group then it will only store numbers in the table, and I don't really want to use a combo box...