Search results for query: *

I'm trying to run an update statement on my database. It going to change information in one of my tables, but I need to link that table with two other tables to figure out which records need to be updated. I know that that statement should look something like this: update s set s.status =...

I was hoping that there was another way to do it. It's taking to long with the insert statement embeded in a for loop.

As you could quess from the title, I'm trying to insert into table more than one record at the same time. I'm looking for the syntax in SQL. I'm not inserting from another table. I've just got a lot of records that I need to insert at the same time. I know how a single insert works, but I'm not...

Hello, I've been interting into a table with a series of the following statement in a for loop. INSERT INTO Tester VALUES (Male, 60,1); I was wondering if I could isert into a table with more than one record at a time, maybe with a multi-dimensional array, or even what the syntax for that SQL...

Hello, If I have a table called 'Mort' and a column in that table called 'Age', I was wondering if there was a way I could sort the table Mort (in ascending order, ie 0..100) in VBA by the column Age. And what the code for that sort would be. Thanks for the help

Hello, If I have a table called 'Mort' and a column in that table called 'Age', I was wondering if there was a way I could sort the table Mort (in ascending order, ie 0..100) in VBA by the column Age. And what the code for that sort would be. Thanks for the help

If there a function in VBA that allows you to pause the running of the program during runtime. For Example, the program's running and it hits a function pause(.5) that pauses the run for .5 seconds? On a side note is there a website where I could find all of these function, like in Java there's...

Hello All, I was just wonder if there was a function in VBA that would let me now if a variable is null. For instance, in Java they have a function IsNull(<variable>) and it returns true if the variable is null, hence the name. I haven't been able to find any way in VBA to check if a variable is...

Hello All, I've got a couple of lines of code: Dim DB As Database If ObjectExists(acTable, &quot;Deaths_AmtTab_Agg2&quot;) Then DB.TableDefs.Delete &quot;Deaths_AmtTab_Agg2&quot; End If But when I run the code, it gives me the following error: Compile Error: Sub or Function not...

I'm working with an Access project and I'm trying to access a Forms variables from another Form with the statement: Me.txtPolicyNumber = Forms!FrmPolicyInfo.txtPolicyUnbound But this statement and others like it give me the following error: Run-time error '2450': Big Ben can't find the form...