Search results

I was able to figure it out. I should have thought of this earlier. I had formulas in the excel sheet I was trying to pull info from. I just removed the formulas in the excel sheet and the above formula worked.

I have a query that pulls data & dates from other tables (Note, the tables are actually linked Excel Worksheets). On my query I have 3 date columns; "DUE", "REVISED", and "ESD". What I'd like to do is create a single column that will pull the correct dates accordingly: Always pull from the...

Hold SHIFT, then press ENTER. That should do it.

You can link your pics by changing the Picture Type in the Properties from Embed to Linked. Just make sure the pic is available in the folder, otherwise it won't show the picture. I don't think you can do that to attachments, though. For other attachments besides images, you can maybe display...

ghudson = Thanks, but the code is not working. It won't let me SetFocus any other object on the form. I've tried a few different objects. I was able to just by-pass this and make the button transparent. Since I'm the only one that uses the form I'm the only one that needs to know the button...

Hi, sorry, but I'm not sure where I should put the code you mentioned below. Thanks.

Thank you. But, do I put this code on the "on mouse down" or "on got focus", or somewhere else? To answer your question about the form vs report, I don't know. I'm creating this database and learning as I go. I've been teaching myself how to do things in Access by trial and error. I...

I have a button on my form that has the macro "OutputTo PDF", so the form can be exported and saved as a PDF file. However, I don't want the button to be exported either. Is there a way to hide the button so it is not exported with the other elements on the form? I'm slowly learning VBA and...

mcalex, thank you so much. This worked perfectly. I was able to create a couple qrys and link them, to create another qry that will have it ask the style and the qty, and then it will bring up the price associated with the qty based on the range. So, thanks again!!

Thanks mcalex, for such a fast reply. but, I'm sorry, I'm not following you on the OrderGroup table. I'm attaching a spreadsheet to show what I think you mean. Please let me know if I am way off. Thanks again for your help.:)

So, I'm pretty new to Access, and have been teaching myself as I go along. I am also new to forums to I apologize if I don't explain myself well. I am trying to create a query that will bring up a specific price of a specific style based on the qty on the order. Eventually, I'd like to create...