Search results

Micron, Different screen resolutions are there, but shouldn't be an issue doing that. I was hoping to do it a cleaner way maybe. Thanks for the info though.

Hello everyone, I am looking at the best way to open a form built from a table. In my case a customers table. What I would like to do is on a button it opens a customers form displaying the first 20 or so customers, then at the bottom have a Next 20 button to display the next 20 customers. I...

Just putting my example that works for me in case it helps any. If it seems off to any of you experts please let me know :) I only want to help and hopefully get better as I go as well. Smartslingaro, Here is what I have used for a search box on a form. I have an unbound txtbox on my form...

I appreciate the info. With this current setup, I don't have room for a full list box. What I decided to try and so far it seems to work was I created a Query to display the picture from the Inventory table, and created a form from that query. So basically all it is is a small form (popup) that...

Greetings all, I am looking to see if this is even a possibility or not. I have a drop down list for different products. I also have images on a products form where parts are entered into the database. Is there a way that when you open the drop down to select a product, as you hover over the...

Obviously I'm oblivious to some things it seems lol. Thanks for that info, I'll make that change to avoid this.

I was able to get it to work using the code below. Thank you both Arnelgp and GinaWhipp. I hadn't tried it on the BeforeUpdate event before getting this to work. I just noticed I had a hard time getting the form to validate beforehand because these validations were based off of 3 different...

Hey everyone, I am need of help once again. Working on a simple expense tracker database. On the form I have two different comboboxes that based on certain selections with make some textfields visible. On the first combobox (ExpType) there are 3 different options within the list that if selected...

I have seen numerous posts across different sites that point to a FIFO style setup. My only issue with this is on the order form I am using, only the Product and Quantity fields are visible, so all the costs are based off a calculation. My biggest problem I am running into is when all the stock...

Sorry for the title, not sure the best way to word it. So my question is for all you experts, (thank you all by the way for everything, ya'll have helped a LOT) I have a two inventory tables with forms (well subforms on a mainform) that have a part cost associated with them, and a selling price...

Thank you all for the help, shortly after posting this (which was way too early in the AM lol) I was able to get it to work. Below is what I was able to get to work using some code from other sources as well. Maybe it may help someone down the road also. Private Sub JobID_Click() '<-- I...

Ok, I am having a hard time getting this to work. I have seen numerous posts all over the Internet stating to use the below code. However when I place this code onto the Double click event, it opens to a blank record, but if I double click it again while the one form is still open, it will then...

pbaldy, Thanks a million, that did it. :)

Hey all, Ok, I am stuck again of course lol. I have my forms and reports working, however when I click on my button to load the report, the values of the fields from the form are updated to the report unless I save the record then go back to the record. I am trying to load all the values to the...

I believe I have got it working actually, I just put two separate buttons one to print the invoice for the customer, then one to print the order both pointing to records. I was having issues trying to get some of the data to display from my queries to the report (if they were blank as if nothing...

Hey all, I am trying to create a button to clear the entire form in case and not let the data get saved. I have a main form (frmOrders) with two subforms (fsubOrderDetails and fsubOtherInvoicedetails) What I am wanting to is be able to clear all data on the forms and subforms making sure the...

So I finally got my report to have all the correct information, however when trying to still use the code below, it won't pull up the current record I am on, just a blank report. I have tried different ways of getting this to pull up the current record in a report. I know you ask for the...

Yes the JobID is a Number field, It is the Primary Key for the main table Jobs where this information is pulled from. I will try and get a decent copy of my database cleaned up and uploaded, may take me a little to get it uploaded. Until then I do have another question though, as I am creating a...

Greetings, I have tried using the following command, but when the reports loads it doesn't show the current record I am, the report is all blank. Any suggestions? DoCmd.OpenReport "Invoice" , , , "JobID=" & Me.JobID Thanks

Awesome, thanks for the info. I will test that out and see if I did it right 😊 Thanks!