Search results

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...

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?

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...

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?

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] =...

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...

how to compact and close completely out of access the VB command compact and close brings you back to the default access page

ok i have a on load code: Private Sub Form_Load() Dim db As DAO.Database Dim rsv As DAO.Recordset Dim rsmv As DAO.Recordset Dim CurVer As String Dim MasVer As String Dim rs1 As DAO.Recordset Dim Version As String Dim Updatemsg As String Dim rsupdatemsg As...

If a “ ‘ “ appears in a person’s name such as “O’Donnell” the program errors. i need to remove this or replace it with "" (No space) could i use the replace function for this. im not quite sure how this would work Thx -Jim

How do i run a batch from VBA? i want to put the code in my on load event of my opening form. the batch file backs up the database

i have a subform that is filtered by the key of the main form. i want to count how many items are in the subform i tried this but it says i cannot use ".RecordCount = CountR" as read only On Error GoTo ErrorH Dim db As Database Dim rs As Recordset Dim PKey As String Dim...

trying to loop thru all the users who are set to receive a report: On Error GoTo ErrorRPT Dim db As Database Dim rs As Recordset Dim Sendto As String Set db = CurrentDb Set rs = db.OpenRecordset("User Name", dbOpenDynaset)...

iv looked everywhere on the forum but no one has an answer! i need to export names and contact info to outlook without using saved export! PLEASE HELP!any tid bits or maybe a link to some base code to work off of.

I have a login screen and i want to have it so when the user presses the enter button in the password box it logs in. i was trying to lookup the key press event but im not sure how it works.

Ok in my module i have: Public Function ErrorRPT() Dim rserror As DAO.Recordset Dim db As DAO.Database On Error GoTo Errortxt Set db = CurrentDb Set rserror = db.OpenRecordset("Errors", dbOpenDynaset) GoTo Endsubtxt Errortxt: MsgBox "The program has encounterd a error! The error has been...

how do i make a module send a e-mail at 4pm every day? i know how to format the e-mail and i can make a button that dose it but i cant make it automatically send it.

Hello I want to try to learn SQL im new to programming in general i have learned alot of vba for access and i want to do more with querys and learn SQL. is it more difficult than VBA? where are some good free online resources?

Ok i have 1-X diffrent Machine types (around 30 or so) i want to make a report that counts how meny on each machine type there is. First shown on a form then in report how do i count them in report view (like =Count([control])??? or somethig along those lines.) and counting each type and...

i have a module, and im still new to VB so i do not know how to call on it when a error happens. also i would like it to also report what form they where on when the error occur d how can i record this? Dim db As DAO.Databaset Dim rserror As DAO.Recordset Set db = CurrentDb...

ok trying to export to outlook but no luck i have been searching the web for help but nothing any suggestions or resources would be a big help! This button export the contact to outlook: dose not work. Private Sub Command25_Click() On Error GoTo ErrorHandler Set appOutlook = GetObject(...