Search results

Here is the code I have in the afterupdate Me.txt_Date_4_ME_RD = Date. There is nothing in the default and still after the update I'm getting 8/12/2008. That's the date at the top of the form.

Ok I understand that. I don't think explained my problem very well. I've attached a picture of which date field I meant. I need the date next to RD Eng. Or Mfg. Eng. to change to today's date after the user enter's their initials. I already have the code setup in after update.

I have a form with a Date field. That date field is defaulted to = Date(). That works fine. Also there are a series of User Initial and dates boxes next to several question. So basically after a step has been completed the user enter's their Initials and the date is automatically filled in...

Thanks - I had brain fart.

Here is some sample data ProductLineTransAmountTransDateCustomerNameGL$10.0020080715DATSB$15.0020080715DATSA$20.0020080715DATSH$25.0020080715DAOTH$30.0020080715DA Here is a copy of my statement - 22: IIf([ProductLine]="GL" Or "MGL" Or "SBL",[TransAmount],0) Now here is the result...

I have a query set up based on the RMA ID. I want the message box to open if there is a record with matching rma and part id. I don't know how to trigger the message box if there is a matching record already in the table.

I have a list box that on a double click populates a subform. But to help prevent duplicate data I would like to have a message box open based on query results. If there is already a record in the table with a matching RMA and Part_ID I want a message box to open and ask the user if they...

Thanks Jon and Bob. I guess I hadn't really tried to edit the data in my queries in the past. I tried it this time since I have a user that likes to change things he's not supposed to.

Ok this one has me puzzled. I split my database to try out it and see how it works. I have a form where the user enters an RMA number then clicks a cmd btn which runs a query. The query runs fine. However the results get displayed like they are a form in datasheet view. It has the record...

I've got a subform (frm_Edit) in datasheet view. The record source is a table. The main form (frm_RMA) has a combo box whose row source is - SELECT tbl_RMA_Inspection.RMA_ID FROM tbl_RMA_Inspection GROUP BY tbl_RMA_Inspection.RMA_ID; I need the user to be able to choose an RMA number from...

Is it possbile to click a btn to run a query then follow a hyperlink? On my form is a part #. Each part has a drawing associated with it. The drawing file is located on a server. The location of the drawing is stored in the part table. My form's control source is QA_tbl. I have a query set...

Awesome thanks Bob for pointing me in the right direction. I got it all figured out now.

Macro1 outputs the query to excel. Can I move that into VBA? I've never tried that.

Ok - I'm stumped. I've been assigned a task of having a query export to excel. Not a problem but the button has to on a form someone before me created. There are 2 btns on the form. The first one (Preview) opens the report. The second one I created (Command7). Command7 runs a macro that...

Well now I'm coming up with a Run Time error when I double click on the entry in the list box. Run-time error '3075': Syntax error (missing operator) in query expression 'Receiving Lot Number = 15035' Here is my coded: DoCmd.OpenForm "QA_Supplier_Quality_Lot_Edit_TEST_frm", , , "Receiving...

Oh, I was using the name of the control and not the name of the field in the table. I'll try changing it and see what happens.

I have 2 forms setup. The user enters a part ID and date range then clicks a button to display the results in a listbox. From there I would like the user to double click the record they are looking for and then have the other form open so they can edit the record. I can get the second form to...

Awesome, thanks Bob. I want it gone.

Thanks for you help Adam!

I need to remove all the "*". All I want is the company name. Example - this is what is currently in DB * ADT SECURITY SERVICES I want ADT SECURITY SERVICES