Search results

I have a GUID/ reference grabber in excel, does someone have one for access, I get tired of having to set references on different computers, easier if a script sets them when I open my personal template.

funny that if I put the script as a function it will work, but not as a vba macro Function test3() MsgBox "Good To Go" End Function

I have the following script to add a commandbar, however I can not get the onaction script to call the macro, the macro is located in a module. Sub AccessButton1() On Error Resume Next CommandBars("MyCommandBar").Delete Dim cmb As CommandBar Set cmb =...

Are you able to provide the script that I would need as I am not sure how to modify it.

I have the following vba to check if a table exists, but I can not find on the net how to check if a form exists, I tried to modify this script but there does not seem to be a formdef Sub table_Exists() Dim dbs As Database Dim tbl As TableDef Dim dbsExist As Object Dim tablename As...

Ok, I just used a dlookup in the after update event and it is working well now, thanks for your help and patience.

Thanks, I tried some code to select the row in the combo box but it isn't working. Dim s1 As String s1 = Forms![VehiclesF]!Text33.Value MsgBox s1 Combo35.Selected(s1) = True Me.Repaint

so how could I select that record based on the textbox value, can I do a select statement or something similar to make it select that specific record rather than having to manually click on the value in the combo box.

Sorry, I have the ID stored in a textbox, so I have for instance the number 2 stored in it, I then want the data that is on my form to update to that record number, normally I would have to select the record through the combo box that you helped me with, but I also want the option to select the...

Sorry, further to this question, I have the recordset number stored in a textbox and I want it to select the corresponding record in the combo box so that then my data updates, can you please advise how I would do that.

Awesome, thanks

This worked on my home computer which is 2007, my work computer is 2010 and I don't have the third option, do you know the method for 2010?

thanks, I just put a call script and it works fine, call testing

Awesome, thanks for your help.

I have a form named CustomerForm I have a query named CustomerQ. On my form I have a combo box named combo6. Combo 6 lists all of the company names from my customer table and includes the autokey field which is hidden. When I click on a value in my combo6 I want the values on my form to then be...

I have tried calling my macro from a form commandbutton and it can not find the macro, the name of the macro is correct, I have pasted the macro into the form macros and then pasted it into a module but I still get the error that it can not find it. Private Sub Command29_Click()...

Ok, thanks for that

I have the following script to run sql via a commandbutton but I keep getting a runtime error which says - A runsql action requires an argument consisting of an sql statement Sub test1() Dim strsql As String strsql = "SELECT ContactT.*, CustomerT.FirstName, CustomerT.LastName...

Thanks for your help, I will give the script a try, I know that I can store temp queries etc... but I like to use vba rather than to have a database with 100's of queries etc... that may only be used once in a while.

Because I want to create temporary queries when I press buttons, this is just an example to use and once someone provides the VBA then I will be able to modify it to suite my needs, I use vba in excel often but am not familiar with access vba.