Search results

This is my normal way of doing things. Hopefully it will ease some pains. Make sure to have some error handling for this. Private Sub cmdAddCardToCollection_Click() Dim sSQL As String sSQL = "" sSQL = sSQL & "INSERT INTO Collection...

Here is the answer to your post. http://www.access-programmers.co.uk/forums/showthread.php?t=170288

Private Sub txtLastName_Change() cmdFind.SetFocus cmdFind_Click txtLastName.SetFocus txtLastName.SelStart = Len(txtLastName & "") End Sub

use enabled/disabled instead.

Is the CardID an auto number? If so, you shouldn't need to.

You will need a table to store your assets (tblAsset) and a table to store the checkin/checkout of a particular asset. tblAsset AID AssetName etc.... tblAssetCheckinCheckOut ACICOID AID CheckOutBy CheckOutDate CheckInBy CheckInDate etc.....

See if this will help you. http://www.databasedev.co.uk/combo_box_search.html

DVDW, as DCrake pointed out, you should know where the data resides. Then it is just a matter of running a simple SELECT statement to get/search for what you are looking for. Private Function GetPartNumber(byval sPartNum as string) as String Dim rs as Recordset Dim sSQL as String...

That's an interesting topic. I know that you can create hidden tables, but haven't done secured table. I wonder if that's even possible.

It probably make sense since time is always changed, but you can always implement it with Time()

I ran into a small issue like that before and it doesn't have anything to do with the code since it is written perfectly fine. What it boiled down to is a smally delay between the user's machine (FE) and where the Back-end db is stored. For us, the server is stored in a co-location so I...

You can also use the If IsNull(me.text1) = False and IsNull(me.text2) = True then

In the btnSearch_Click event, store the results in a form level variable (m_sPersonIDs) so that you can use that variable through out your form. Then replace your strFilter with m_sPersonIDs Or do something like this Private Sub btnSearch_Click() GetPersonIds End Sub Private Sub...

That happen because in the form record source, the query ask for user input. See image attached.

You could probably have user1 export the data to a text file and user2 then can import into his database. Please note that things like primary key that get increament automatically will change, but since you only use one table, that should matter. Just have the user export the rest of the...

Does this happen to other databases? I had a similar issue before and I ended up importing everything to a new database and that solved the problem.

This should work. Private Sub Update() CurrentDB.Execute "UPDATE Table1 SET Table1.Comment = '" & replace(YourText,"'","''") & "' " End Sub

This only happen to Access, I can right click on other applications just fine. Both the USE DEFAULT SHORTCUT MENUS and USE ACCESS SPECIAL KEYS are checked. I am not sure why this doesn't work.

Suggestion: You should use a ListView control to store you document names and links Attached is a getfile.mdb that shows you exactly what needs to be done to get a file (open dialog). You will need to use SHELL to open the document with its default application. For your file type, you have...

Correct, but the issue concerns with form in design mode. I re-install MS Access and that didn't help so I am not sure what's causing MS Access to prevent me from right lick on form to access the Properties. Suggestions are welcome. Thank you.