Search results

HI, I have an order form with an order details subform. When the user enters in a part number the description and selling cost are auto filled. Sometimes the user will change the selling cost on entering through the record. Problem is that the users are entering through these records again and...

Hi, Need help to double click an image on a form and have it open up in windows office picture manager. Thanks

Hi, I'm using Access 2003 I have a query that searches a parts table by description: Like "*" & [Enter in Part Description to search] & "*" I need to add another search to this query, I added another field to the parts table call manufacturer. I add this field to the above query and added...

Hi, I have some code that will copy a database then compact repair it if no one is using it. I've put this module in an autoexec macro and am trying to run it from task scheduler. When I activate the task the db opens to the module but doesn't run the code. What am I missing here? Here's the...

Hi, I've read quite a few posts on compact and repair but need some clarification. I have a split database; how often should you compact the FE? How often should you compact the BE? I would like to run a batch file through task manager to trigger the back end compact late at night so no one can...

Hi, I'm having quite a bit of trouble with this database getting corrupted. I'm getting different errors, database put in a state that you can't access, can't find bookmark etc..losing data. This just started a week ago, I've recovered all the objects. I went through all the data and removed...

Hi, I'm using access 2010. Is there a way to put a hyperlink to a web page in a memo field? Thanks

Hi, I'm using access 2003. I have a memo field which the customer has entered in data using the enter key to separate his lines. When I show data on a sub form showing in datasheet view this field doesn't show all the text until you adjust the record height. Is there a way when the form opens...

Hi, Don't know much about web programming so I need help.... I have a client who sells parts online, the part pricing is updated through two text files which are being uploaded through FTP. After this is done I need to send a request to the web so these files are looked at. Thanks

Hi, Is there a way to open a continious form to a new record but still show say 15 of the last entries? This form is a bank ledger and my customer would like it to open showing some of the last entries so he doesn't have to scroll up when the form opens. Thanks

Hi, I have a client that would like to print checks. Is there an way to accomplish this I've tried with the report wizard, label wizard and can't get this to work. Thanks

Hi, I am creating a form for a client to be able print cheques. I am trying to convert the dollar amount into text. I see a view posts on this but I'm at a loss on how to implement the code and get it to work on the form. Can someone please help. Thanks

I have a msgbox that shows on a mousemove. As of now you have to click OK to close the msgbox. Is there a way to have the msgbox close when the mouse is moved away from the text box? Thanks

Hi, I have a customer who sells auto parts. He has asked me that when he opens the parts form to a part an image of the part will show. He has a folder with all the part images and they are named with the part ID. I know I could do this by typing in the path to each part but there are over 1000...

Hi, I have a stock date field, this field is set to short date. On one form this field shows the stock date but when you click in the field the field expands and shows date and time. I've looked everywhere and there is no way that the time should show. I now have some querries that don't work...

Hi, I have a list box that holds waybill numbers, what I'm trying to do is get the numbers from the list and insert them into an email. I already have the email setup but as of now the waybill number is coming from a text box. Does anyone know how to accomplish this. Thanks Geno

I've added this code to the on delete event of a subform: Private Sub Form_Delete(Cancel As Integer) DoCmd.SetWarnings False If MsgBox("Are you sure you want to delete this Credit?", vbYesNo) = vbNo Then Cancel = True MsgBox " This Credit has not been deleted" Else DoCmd.OpenQuery...

Hi, I have a parts table with a field that holds a vendor's name which is selected from a combo box on a parts form. I've just noticed that if a vendor name is changed on the vendor form the field in the table isn't updated. I now have to go through all parts to adjust any changes done to the...

Hi, I just installed the office 2003 service pack 3, I then opened a database I'm working on and the combo boxes don't show any records. They are there but can't see any of the records. After uninstalling the service pack the data now shows. Has anyone had this problem? And if so did you get it...

Hi, I have a form for parts, what I need help with is if the customer wants to add the part to a purchase order he would like to click on a button and if there is an exsiting PO open add this part to it. If there isn't any open PO's then he wants the choice to open a new PO or cancel it. I have...