Search results

Im getting "Data type mismatch in criteria expression" with that. I tried selecting from another column and cstr. EDIT: I dont know if this matter but on a side note, I am attempting to edit the record the form is currently on. I have a button that allows you to select the persons ID and it is...

Im getting "operation is not supported for this type of object" for rsCustomer.FindFirst "[ID] = '" & ID & "'". any Ideas? its been a while since I have touched access 2008 or so. Private Sub selectId_Click() Dim fDialog As Office.FileDialog Dim varFile As Variant Dim dbObj As...

yes, it seems to only display pictures

But the PDF is an attachment to a table, i dont think that can be pathed?

what version of access are you running? have you tried creating a multiple items form?

Im having a little trouble understanding what your after here, you want a checkbox for each record in your Query? or table? maybe a little more detail about the project will help us to better understand what your trying to accomplish here.

What are you trying to do? add 5 days onto the date?

I have multiple attachments in PDF format and id like to view them on the form itself. how do i get the attachments to show up on the active x control?

So i looked up the find function: here is the example it gives With Worksheets(1).Range("a1:a500") Set c = .Find(2, lookin:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.Value = 5 Set c = .FindNext(c)...

i have never used the Find Function im comming from Access VBA so this stuff is new to me I looked up the find function and im not quite sure how to implament it into the code.

I Need to copy the ajacent cells for each instance of the word without copying the same row multiple times (if the word apears in that row more than once) not too clear on the find function if its possible with this.

Im Trying to search for something on another sheet and copy it over to the search sheet as the search results. For the search id like it to return anything that has for example the word "test" in it so if i put "Test" in the search box i want it to recongnize things like "Testing1", "initial...

looked into it encrypted the back end and had to relink all the tables on the front end and re distribute the front end because the auto update will not work because it cant check versions. just made a batch file and sent it out to everyone to copy over the new front end.

any thoughts on how to do this? tried making a prompt on load but you can just right click on it and close it..... cant encrypt it with the built in encryption because it says wrong password on the front end. anyone have any ideas?

Work great thanks!

ok im trying to lock someone out of the database after 3 log in attempts here is what i have: Private Sub Ok_Click() On Error GoTo ErrorRPT Static LogonAttempts As Integer Dim SaiCurrentUser As String SaiCurrentUser = "" If DLookup("[Contact]", "[User Name]", "[User Name] =...

you would have to base your combo off of a query

ahhh changed to this: SELECT [Main Inventory].[Sai Serial Number], [Main Inventory].[Software installled 1], [Main Inventory].[Software Key 1], [Main Inventory].[Software installled 2], [Main Inventory].[Software Key 2], [Main Inventory].[Software installled 3], [Main Inventory].[Software Key...

Humm still comes up with the other owners is there a way i can do the where in the select function to initially select "ECI" from the owners?

this code should bring up the owner "ECI" and all the other criteria falling under ECI but its bringing up everyone it is not adding the ECI critera. Just the Server, desktop, tablet,and laptop criteria regurdless of who ownes it. PLEASE HELP IM A SQL NOOB! SELECT [Main Inventory].[Sai Serial...