Search results for query: *

Hi, I would like to display the contents of the text box which the mouse is over (that is a text box not associated with this application, e.g. the internet explorer address bar), into a text box within a form in my application, say textbox1 . Does anyone know how I can achieve this? Much...

It now says Syntax Error: Expected expression . Any ideas? ================= Warren Brown wazzer@btinternet.com =================

Could somebody please tell me where the syntax error is in this vba statement? (note all one line) DoCmd.RunSQL (DELETE tab_Requisitions.[Requisition Number], tab_Requisitions.Date, tab_Requisitions.[Account Number], tab_Requisitions.[Estimated Amount] FROM tab_Requisitions WHERE...

My experience of Access is very limited, can you be more specific please? Thanks ================= Warren Brown wazzer@btinternet.com =================

Is it possible to delete records via a macro or via vba coding? If so how is this achieved? Thanks ================= Warren Brown wazzer@btinternet.com =================

Is it possible to call a macro from within vba code? Thanks ================= Warren Brown wazzer@btinternet.com =================

Hi, I'm reasonably new to access but I think i'm over looking something very simple. I have a query set-up to retrieve dates matching a certain number (account number to be exact), both of which are stored in the same table. So in this query I have the account number field, and the date field...

In a form I have a combo box. However, I want the values that appear in the combo box to be the result of a query. However in order for the query to work I need a value entered in a text box in the form to be passed to the query to give an output from the query to go into the text box. How do I...

sorted, you're right it was a bound text box. ok next problem sorry :) I slightly modified your code like so: Public Function Table_Gen(ByRef RecVar As String) MsgBox RecVar Dim fld_a As Field Dim fld_b As Field Dim fld_c As Field Dim str_sql As String str_sql = "CREATE TABLE " &...

problem is though the textbox isn't empty and the names match, do i need to put some identifier before it, like it standard vb you could put: passvar = form1!textbox1.text ? ================= Warren Brown wazzer@btinternet.com =================

Here's the code so far: Private Sub cmdOpenAccount_Click() Dim PassVar As String DoCmd.GoToRecord , , acNewRec PassVar = txtAccNum ''Error comes here (on mouse over says "txtAccNum = Null") Call TableGen(PassVar) End Sub ================= Warren Brown wazzer@btinternet.com...

Problem is though it says "Invalid use of Null" ================= Warren Brown wazzer@btinternet.com =================

Sorry this thread seems to go on and on but now i've put what you put it says "Invalid use of Null" ================= Warren Brown wazzer@btinternet.com =================

thanks a lot, just one more thing though. I want the table to be called whatever has been put into "textbox1". Then I go PassVar = textbox1.text Call TableGen(PassVar) and pass to Public Function TableGen(ByRef RecVar as integer) (above code) End Function but I get the error...

Hi there, Please could someone explain to me how I would create a table using purely vba code. Let's say I want 4 fields in it: f1, f2, f3 and f4, with f1 as the primary key, all of type text. How would I go about it? Thanks in advance. ================= Warren Brown wazzer@btinternet.com...

Ah if you're on a network it's different, i'll try and look up something for you tommorow then get back to you, however if anyone knows off hand feel free to interupt me. ================= Warren Brown wazzer@btinternet.com =================

Go to Tools - Security - User and Group accounts. Now set up two groups, one called "Engineers" and say "Users". Upon creating the groups you will then need to close this and go to Tools - Secutiry - User & Group permissions , set the appropriate read / write privliages for...

Thanks :) ================= Thankyou Warren Brown wazzer@btinternet.com =================

Hello I was just wandering how I could manage sub-forms in the following manner. I've got a main form A, inside it sub-form B. Now I want to close sub-form B and open a new sub-form C within A. Can this be easilly done? Thanks for your help in advance. ================= Thankyou Warren Brown...

oh also is it possible to call the location of the remote database from a field within a table? ================= Thankyou Warren Brown wazzer@btinternet.com =================