Search results

Thanks for the reply. I can change it manually. The table is shared between two massive DBs and I was concerned about the effects changing it would have in the other applications. Would that be problematic?

Seriously I know there has to be a simple line of code for this. I want to set the AllowZeroLenthString property for one field on one table to true just long enough to run an update query to clear out the fields for preperation of new assigned numbers. I don't want to permenently set it to...

Thanks bro. I just couldn't pull it out of me memory banks. I only needed one field. For future reference how would you inlude the other fields but group by only one field? I'm fixed for now though. Thanks!:D

This one should be really simple. I need to filter out only the first instance of a field that returns multiple instances in a query. IE (query result I get now) Example A Example A Example A Example B Example B Example B I need to get back Example A Example B

I had the same issue and moving the formating to the form from the table worked like a charm. Thanks!

Thanks JBB! The site set me straight! My next task is to keep the info in sfrmInfo from inserting into an existing record. Thanks again! AWF Rules! :cool:

Great site! I haven't had a chance to try the fix yet. Thanks for all your help!:)

Sweet! I'll give er a try tomorrow. Thanks!

I have a Form with two subforms. The user enters a value into a textbox named NUMBER. The OnEnter event populates sfrmInfo with the fields; NUMBER, LAST_NAME, FIRST_NAME, ADDRESS. I have some validation code and if the NUMBER is valid an Add Record command button appears and they can then add...

I follow all but 1) Image File derived from a Query Image File: [YourReference] & ".jpg" I know this seems elementary but what is a query image file?

This report is being generated using a command button. I tried this from another thread. I have a Module with this code in it: Option Compare Database Public Function GetPic(DOC As String) On Error Resume Next Dim mypath As String Dim MyFile As String 'Path were pictures are stored mypath =...

Thank you for your replies I am going to work with them today. What I'm really stumped about is the fact that the image.jpg will change every time the report runs. In the query there is a field with a unique identifier that will match the .jpg that identifies the individual (example: 12345...

I have a report that pulls up an individuals information from a query. I have a folder where images of these individuals are stored. I need to link up their image with the rest of their information on the report. The report prompts the user for an ID #. This ID # is the also the file name...