Search results

Thanks Pat. At the risk of sounding a total dummy, how do I do that? I'm very new to this so please make it simple.

Frozbie, sorry I haven't explained this very well. The form is in db2 and it takes the table created in db2 as the recordsource. I've tried linking them, pausing it, doevents, adding a button so I open it manually, yet it sometimes works and sometimes doesn't, even when all the testing settings...

Yes you're correct, that's the way it works. Unfortunately when I try to refresh the form it can't find the recordsource (which is the table that has just been created) This has been driving me mad for nearly a week now and I know it'll just be a one liner that will fix it, it always is.

Hi, I've been reading this as a potential fix to my problem. I've tried it and I get the error "User Defined Type Not Defined" on the line "Dim dbs As DAO.Database" I'm probably doing something stupid but would appreciate the help

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

Thanks for all the replies, I appreciate it. I tries the decompile that you recommended and it shrunk the db drastically. Very impressive. Unfortunately the form stil doesn't work properly :o) Never mind, I'll think of another way around it.

Thanks for the reply. I wish it was that easy. Problem is, sometimes it works, sometimes it doesn't, even with exactly the same criteria. I can run it and it brings back an error saying it's unable to find the query or table which is the recordsource, then run it again and it works fine. Run it...

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?

It's worth a try, thanks for the reply

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

Again, I would but it displays them as continuous forms so I wouldn't know how many to create. I appreciate your help on this, and I apologise if my database seems a bit wierd but it's my first attempt so I'm learning what not to do as I go along. Once I have delivered this as a working v1.0 I...

I would but they're multi-select list boxes. No matter how I do it I'm still confused as to why this code would work in debug but returns an error in runtime. It definately finds the form, and when it opens it during debug it requeries it on Form Load. I've tried putting a delay in to see if...

Thanks for the reply. I can't use the SQL because the query is built up dynamically depending on what they choose on a previous screen. If I go in and manually look at it, it's fine, but it doesn't seem to see it during runtime.

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

I was filtering using a field in a table I was creating. If I'd copied the whole code ( which would have taken up too much room) it would have shown that I'm doing a SELECT INTO statement. The table I was creating was tblResults and I was trying to filter on data that wasn't there yet... strSQL...

DOH!! spot the stupid mistake. Sorry to waste your time.

Thanks for the quick reply. I tried it and I still get the same response. This is the code.... Me.StartDate = Me.CalStart.Value Me.EndDate = Me.calEnd.Value strSQL = strSQL & " AND ((tblResults.DateNumeric) Between (#" & Me.StartDate & "#) And (#" & Me.EndDate & "#)) "...

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 ('" &...

Genius, it worked, cheers mate. Out of interest, what's the difference? Why would that work when it's concatenating the same details other than spaces?

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