Search results

Why? Why? Why? Unable to see new table. When I run an sql statement to create a table in one database while connected to another, how come access can't then find a form in the database where the table has been created, which takes the new table as it's recordsource? Please help, I've had...

I've asked this question in different ways and haven't had a reply that fixes the problem yet. I'm getting desparate so I need to ask it again. Why would something work in debug but not in runtime? Is there a problem within access where it doesn't keep up with changes made with vba?

Is it possible to automatically run the command behind the F5 function key (Refresh) so it updates the queries or Tables screens?

I'm having a problem opening a form that relies on a query as a control source. I keep getting the error saying that the query doesn't exist, so I wrote the following code to see if it actually does... For Each Qry In thisdb.AllQueries If Qry.Name = "qryResults" Then If...

Hi, I'm going mad trying to add this line to an sql statement. It works fine without it but I get an error saying one or more parameters is missing. Me.StartDate = Me.CalStart.Value Me.EndDate = Me.calEnd.Value strSQL = strSQL + " AND ((tblResults.DateNumeric) Between ('" &...

Hi, I'm having a problem trying to run an sql statement where I get the error Run Time Error - No Value Given For One or More Required Parameters. I know that the sql works but I don't know what I'm missing to get this to run. Can anyone help please? This is my code... Dim cnn2 As New...

This is driving me mental!! I'm trying to find the last record in a database so I can increment the next record by 1. I use the code rs.MoveLast but it only moves to the second last one and doesn't seem to see that there's another one after it. What am I doing wrong? Please help for the sake of...

Is it possible to run an update query which is part of another database? I have an update query that I would like to run but it's in a different database than the current one. I know I can import queries etc but I just need to run it as it updates tables in that database. I don't think I'm...

Hi, I'm new to this Access ,SQL and VBA world so would appreciate some help. I have a database currently sitting on a shared drive, and I am accessing it from a local version on my c drive. I need to create a table on startup that takes data from the main database for use on the local version...