Search results

I was able to assign the values correctly, my error pointed me back to the indexing of certain fields that were non autonumbers. With that said, when I scan the bag number, and the after update VBA takes place, it writes the values to the table (duplicating the record). So I then have two...

Yes I want to navigate to the existing record, after update. At the same time I want scan several bags to also view their records on the same subform. The bag number is a text field. I want to update the existing record from my main form. I'd like the data to be time stamped after update. The...

Make sense about the autonumber field. How would I get the value of the PropertyID to fill correctly then? I am using my form to update this and several other records by a continuous sub form. The first field, BagNum, has an after update event with the code from post #3 behind it. Where...

I am still having issues with the last DLookup. Instead of returning the value, it pulls a new record value. For example if the DLookup value is 42, it returns 75 (or whatever auto-number is next). The previous two values return fine. Me.PropertyID = Nz(DLookup("PropertyID"...

Brian, That is working really well for me. Quick question, since my sample only returned one value and my real working project has many, is there a limit to the line: Range("H18") = Worksheets("pp" & n).Range("I22") As of now, I have ran it with returning 14 values with no issue. Would it...

I attached a snap shot of the control source of PropertyID. It doesn't have an expression behind it. I tried adding Option Explicit, then adding Me. Option Compare Database Option Explicit Private Sub Bag__AfterUpdate() Me.DateIn = Nz(DLookup("DateIn", "tblPropertyDetails", "[BagNum] = '"...

I am doing something similar to a library system, except it is property. For this you scan the bar code which returns a number. I am running into an error on my last item PropertyID = Nz..... It produces a run-time error, you can't assign a value to this object. I am confused because the...

I attached a sample of what I am attempting to do. There are 4 sheets: Summary PP1 PP2 PP3 On the summary I want to enter a value from 1-26 (in this case of my sample it is 1-3) and run my function...

I am taking over a 5 year old payrole record keeper project, where every employee manually enters their work hours. For individual records, each excel file has 28 sheets! A sheet for each pay period, a sheet defining the pay periods, and a summary sheet. On each pay period sheet, there is a...

Joe had mentioned that the end result was 6.5, based on the excel file that his client had given him. I was asking if he could post the formula from the excel file to see how they are getting 6.5 instead of the 6.3

pbaldy: i'm getting a total of 6.3.... I think we still need the excel formula to help.

Can you post that formula that gives an end result of 6.5? Basic math gives a number of 6.297647058823529, so the formula may round up or down to the nearest .5.

Good afternoon, I recently took over another database that is specifically used for holding and tracking individual’s property. Any individual can have more than one property (bag number) while visiting. Each property bag has a bar code. The bar code is scanned into a subform while entering...

Funny that you mention it. I just figured it out and was about to post back, I must be loosing my mind! That leads me to my next question, do you know how to add a filter to search by two dates to that form?

I have previously worked with the link below on two other databases with great success. My company wanted to implement a search on another existing database but for some reason when I type characters in the Search For, it will not narrow down the results. I am using the exact same form, code...

i am 99% sure this wont work. as soon as you create the new .mde or .accde file on the server, and when the user opens their desktop version, it will automatically begin the delete and download process. If Me.Dirty Then Me.Dirty = False Basically it saves the form if you check chkDoNotShow...

Musclecarlover07, I posted a similar question not too long ago and had a lot of help from Mr. Boblarson: http://www.access-programmers.co.uk/forums/showthread.php?t=235939 There are two main parts: Part One The auto update that I use is located at...

Good evening, I have been messing around with a code that I want to apply to the form close command. Right now I have a form specifically designated for adding new records. When a user closes the form, I would like an email generated capturing the form in a pdf and automatically sending it...

JANR, Thank you, works like a charm... Thank you to everyone else for the feedback and suggestions.

Spikepl....thanks for the info. I researched and in fact it does not work. Based on my code from the first post, any suggestions on making it work?