Search results

yes, I wanted to change the Source Object so please forgive my wording as obviously RecordSource refers to something completely different, but as previously Identified by DBguy, Source Object is for SubForms so I am going back to the drawing board. Appreciate everyone's input

Wondering if someone can point out the obvious as I seem to be missing it more and more lately. I would like to use the same form for entering notes, however, depending on underlying form that it is launched from, the Record Source could be different. I am using a double click event to launch...

I put the macro in the wrong spot on the properties :banghead:, its working on the form, however if I add it to a text box, I get the regular Right Click menu. Ill check out your demo EDIT: I added it to the subform containing the text box and it works. Think its time for bed......

Could you post that zip file here? Its telling me I need an account to download it. Here are the screen shots of the macros and form properties, I just used the same names as the tutorial for the macros

That is the story of my life :banghead:

I am using the full version of access to create my database, however the end users only have the Access Run-Time so there is no Right Clicking. I followed the steps shown here, however whenever I right click, I don't get the menu. I set it on the Form Properties > Other Tab For my commands...

I just deleted the report, made a blank report and then added each query as as a sub report and its working. I think originally I used the report wizard to make a report based off the first query and then dragged the second query onto that report to make the sub report. Guess access didn't like...

No Code running in the back ground Sub is not linked to the master, they are each populated from their own query, just displayed on 1 page

I have 2 select queries that run to populate an access report whenever the report is opened. The first query gathers facility information and the second gathers all sub records for that facility based on specified criteria. The issue is whenever I open the report, its only displaying 3 of the...

Figured it out WillContinue = Not (.NoMatch) If WillContinue Then Me.Bookmark = .Bookmark Else MsgBox "All records have been searched" End If End With Thanks again for all your help !!

Figured out how to get the "not found message", now just need some guidance on how to display a message once all records have been searched with the .FindNext. Here's what I have so far Static WillContinue As Boolean Dim Rs As DAO.Recordset 'Checks to see if there is a search...

Sorry for the late response but was traveling yesterday. Schema data is the structure of the the XML file, i.e. Coding to tell the reading program how to process it. Depending on how your exports are setup, it could include the Schema information as well as the data. If not all the files have...

does your XML files have schema data? Try changing acStructureAndData to acAppendData

Got it working!!! I was testing your code in the button on click, however I had my old code on the txt after update so they were conflicting. I placed your above code, to include the .findnext, in the txt after update and call it from the button on click this way it immediately searches for a...

So I tried arnels first posting and no matter what I enter, if it exists or not, it just selects the name field on the first record. I have these 3 columns setup so no duplicates can exist so I commented out the following and still get the same results Else .FindNext _...

Can I do a set focus with this setup? Currently once it matches, it selects that field i.e. "[Serial Number] Like '*" & Me.txt & "*' me.[Serial Number].SetFocus OR " & _ "[Asset Tag] Like '*" & Me.txt & "*' me.[Asset Tag].SetFocus OR " & _ "[Name] Like '*" & Me.txt &...

For this one I just want it to go to that record, I do however have another form for a different purpose that filters based on the results, but i'm doing that with an access query.

Currently I have some code setup to search a table for a specified string, based on the search criteria of either Serial Number, Asset Tag or Name. What I would like to do is eliminate the need to select the search criteria and be able to just enter the search string and hit enter to have it...

I never get discouraged, I just wasn't finding what I was looking for so thought I would post here as you guys have been a great help on past questions, while I was on the hunt....

After a little more searching, I got it to work with the following DELETE FROM RMAs WHERE NOT EXISTS (SELECT * FROM FacilityEquipment WHERE RMAs.RMAID = FacilityEquipment.[RMA ID]);