Recent content by ximistar

Hi everyone, I am trying to export a report to an Excel spreadsheet and I want the data in the report to be pasted into certain fields into an existing excel spreadsheet that already has been created with formulas. Is this possible? if so how!!!! Thank you

Hi guys, Please see the attached image. The checkboxes that I have circlued in the attached image. I want these boxes to determine how many email templates need to be opened for that parituclar company address attached with a pdf of the form. For example. User ticks Amros and LNL box...

Update, I decided to create a new form with the same details and it works now. Must of been a bug with the other one. Thanks for your help guys!

Hi, When I right click on the tab and click on save it still does not save the updated fields :( Thanks,

Hi guys, I am having the following problem. I have a List box on my Form and I am updating HP 12A to quantity 2 and then clicking save and then closing it. When I go back to 12A it shows the quantity as 3 again so it doesn't seem to have updated the record. When I go into the table and update...

Hi! Thanks so much this is exactly what I was looking for, works a treat. Much appreciated.

I have this code and it is working fine. But I now want is those IF statements that I stated above. So it is easier for the user to know how much quantity of each toner to Order, let me try be more clear. Table 1 (Toner Stock) Toner Name Quantity HP 55A...

Hi JHB, what I would like to do is get all the toners in my database that are below quantity 2. Once that is done I would also like the query to update the quantity field making it a total of 2. so if toner HP 78A is quantity is 0, I want the query to +2 to that. If toner HP 45A is quantity is...

Hi guys, hope you are all well. I am using the Query design wizard and I have selected my table "Toner Stock" and the fields Toner and Quantity. What I want this query to do is the following: I want it to get all the toners showing <2 as quantity. Which I have done previously using the...

Thanks for your reply guys, I have used the query and works a treat! Thank you

Hi Minty, Yeah I wanted a button on each record as that button will transfer the user to an Email template for that chosen company. But it is okay I have just added them in the footer for now. Thanks.

Hi guys, Hope you are all good. ] I have a form showing the Toner stock list in my School. I am planning on adding a button to my Form called "Generate Order". The logic behind this button is to grab all the printer toner names that are showing quantity at 0 or 1. into an Excel spreadsheet...

I basically want, a button next to each field which generates a automatic email template for outlook for that particular fields email address. I guess there's no way to do it, thanks for your help.

Hi Minty, Thanks for your reply. Okay, so how would I create an individual button then? Thanks.

Hi Guys, I am having some problem with creating buttons in Reports. I am trying to create a button after each column (please refer to attached Image) When ever I click on Design > Button. It creates 7 buttons automatically (as I have 7 fields I assume) But when I go to delete one it deletes...