Search results

I have a database with over 100k records and I want to use a combo box to search for records by typing in the name. I found code to do this at: http://allenbrowne.com/ser-32.html. This is working, however i have many fields on the form that I want to populate from the table after the...

Yes, it is a listbox with a checkbox feature and setting allow additions to No did the trick. Thanks so much. I have to find how to set this to solved....hmmm.

I have a listbox with checkbox's based on a table. The listbox reflects everything great, except it shows an extra checkbox at the end of the list that does nothing. I think this is the "next record" from the table, but I don't want this to show. How do I hide or get ride of this extra...

Thank you for your time. I don't believe I am explaining my issue clearly. I know how to use sql as you have stated, but in this case, it isn't as simple as that. I will, however look at reworking the entire thing and find a better way to do this.

Yes, possibly I should do the min max as a separate sql and append to my table, but I'm stuck on how to procede with that too.... Attachment1 is a snapshot named "loop1" that reflects the query that the vba code loops through to find the first "true" row Attachment2 is a snapshot named...

I have a query that has a column with “true” or “false” in it. I have vba code that loops through all the rows and finds the first “true” value in a column and saves certain info to a table based on that first row of the record set; it continues to loop until it finds the first “false” value...

This is close to solving my problem. I too want to have a sequencial numbering column in my query as follows: ID seqNum 475 1 475 2 475 3 480 1 480 2 490 1 490 2 491 1 etc. I tried this as suggested: NextSeq = Nz(DCount("*","Tbl_residence","CLIENT_ID <= " & [CLIENT_ID]),0)+1 But my...

After research I can see how this could be done....however I found a much simpler solution. We'll add a field to the user input screen and have the info we need....as usual I was making it harder than it had to be. thanks for the information. To be more clear....I discovered we only needed...

· I have emails with excel attachments coming in multiple times a day to outlook. · I want to click a button in Access and automatically import the last excel attachment in my email in box based on the timestamp of when it came in (thus getting the last one). Does anyone know how this can be...

I started with the code written by someone else. It is located at: http://www.datagnostics.com/dtips/multiselect.html I changed it slightly to save the selections from a list box and also allow the user to add information in an input box for each selection made. All seems to work well, if I...

Okay, yes, this is working great....so easy! thanks.

I am beginning to design a new Access application. I need to link to two separate Oracle databases. I know how to use odbc to link to one database, but how can I link to two different ones at the same time? Thanks.

Has anyone used Access to create an HL7 message? My thought is to import a csv text file to Access, create an HL7 file, then export that file. I'm open to any and all ideas. I'm just in the thought process of how to do this right now. Thanks.

MS Access 2010 My query reflects a date field. some dates reflect as this format: 1/19/2013 12:00:36 AM some dates reflect as this format: 1/19/2013 I want to use the query builder to say: IF date format is like 1/19/2013 12:00:36 AM, then something..... IF not, then something else. I tried...

'Go to last record in table1 DoCmd.GoToRecord , acLast 'copy last record (row) in table1 'insert last record as new record with one value changed So last record in table looks like this: and new record in the same table looks like this: Thanks

The following code checks the value of field(7) to see if it is "true" or "false". It loops through each record until it finds a "true" value and makes that the "start time". It keeps looping until it finds a "false" value and makes that the "end time". It stores the calculation in the "Diff...

Problem RESOLVED. In case anyone is interested. I found code that will work. I store it in the PERSONAL.XLSB macro. This may not be pretty, but it works! yay! Thanks everyone! Sub PrepData() Dim RwExt As Long Dim StrFile As String Dim folderPath As String Dim pinNum As Integer...

Rx: Thank you for your new thread information, however I am still not getting the end result I need. Attached is your Access db, with my code. When I get to the line: RwExt = ActiveSheet.UsedRange.Rows.Count 'this counts the number of rows on the sheet There is a problem. No rows are...

Here is my current code. It is working great except that it doesn't loop to the next file in the folder. It stops after the edits are done and saved in the first data sheet. I have this code in the first spreadsheet macro area. Should it be someplace else? Option Explicit Sub...

Using the number for the sheets works great and solves that issue. Now to figure out how to get it to loop through each file in the folder.. ?? .. Thanks to all who helped me get this far!