Search results

Thanks for the reply. Either the left or the right. The left usually(~) and the right(-). They are serial numbers and they come from many different mfg. and are all a little different. My issue is that with a certain mfg. the have (-) in the middle and some annoying person here at work is...

I can't see your data either but if you are inserting from a form to a table you can use SQL INSERT/UPDATE. If you want a field updated through a form to a single record then you can use a button and code it with Me.FieldName = Rate. If you have to work out of the datasheet there is a datasheet...

What do you want to change the null values to? As Lagbolt suggested DCount will give you a count of those records in quantity. If you want to find those records then DLookup will find records that satisfy criteria. I usually use "If" statements and then SQL to update records.

Did I make it on time? I don't think you can.

Is there a way to limit just the outside of the string to alpha numeric but leave the middle of the string as is?

When I use DoCmd.Quit (acQuitSaveAll) it closes the database and Access at the same time, if I use DoCmd.CloseDatabase it would close the database but leave access open. I would think you could use a simple Yes/No MsgBox to give a warning before closing. Not sure if this helps at all but just...

I am looking to either embed an Excel sheet into a report/form or have the data in Access export to a pre-formatted Excel sheet. I know how to export to Excel but not how to get it to export to specific cells in Excel. My Excel template(attached) has space for 15 records and the Access data will...

Thank you so much! It works!!! Finally I don't have to go through each record and delete these(~) ugly little things.

Thanks for the reply. I have been busy so I haven't had a chance to get to this one yet. Where would I place this code? It seems to me to be outside of the private sub. Thanks again for all the help.

I would like to know how to limit a field on a form to only Alpha Numeric characters. Example: ~AAUZNTO This would be scanned by a bar code and I want the field to show only this when scanned: AAUZNTO Any help would be awesome. Thank you.

Yeah that was it. Found it like 2 seconds after I posted this. I spent 2 hours already with this problem. haha. Thank you so much. People like you make the world go round. Cheers!

Thanks David! This works except I get an error if the previous occurrence does not have a complete date. I get a null error. Now this won't really happen in real time because we won't receive a unit again until it has been completed but I would like to know how to circumvent this error message...

I created this label print button in my database and it worked fine. Now when I put it on the app server at work it has a problem with this code:Dim ObjDoc As bpac.Document It says it cannot find it. In my first working database it has this "bpac" library in the database as when I type the...

This is for a repair database. I currently have a DCount to determine if a unit was previously in for repair and a msgbox that gives a warning to check for a warranty sticker. I want to have a field(incoming_disposition) changed to 'Warranty' if the last occurrence(DMax?) of the...

IT'S ALIVE!!!!! Thank you so much for your help. Here is my final code: Private Sub btn_submit_Click() Dim autoID As Long, maxDate As Date maxDate = Nz(DMax("complete_date", "tbl_module_repairs", "incoming_module_sn = '" & Me.txt_sn & "'"), Date) autoID = Nz(DLookup("prikey"...

Thank again for the help. I am getting a syntax error on this part: autoID = Nz(DLookUp("prikey", "tbl_module_repairs", _ "incoming_module_sn = '" & Me.txt_sn & "' AND complete_date = #" Format(maxDate, "mm\/dd\/yyyy") "#"), 0) I think it might have to do with the date part...

I get what you are saying about auto number. It has been sequential up to 53,000 records but I trust your judgement. These repairs do have completion dates(named: complete_date) that could be used to pull the last/highest date. However the 1st form I need to only enter the serial number. Could...

Well it's my bosses DB I have been trying to update. It does have a auto number(named: prikey) created for each record so maybe a dual criteria could be used(as I am guessing DMax pulls the highest value)? If that won't work I was wondering if I could use unbound controls on my form and insert...

Thanks for the reply. This works to open the form on the serial number but it does not pull the latest record for some reason. I entered 2 identical Serial numbers in my table and it pulled up the 1st record not the 2nd one. Any ideas? Thanks again.

I need to use DMax to open the form on the last record based on the serial number. This code is what I have to open the form currently, but I want only the latest record related to the serial number: DoCmd.OpenForm "Form1", , , "incoming_module_sn = '" & Me.txt_sn & "'" Here is what I tried and...