Search results

Thank you - I appreciate the answer - you explained it simply and I like that!:D

Hi, I've used docmd.openquery to run this stored action query below and it works just fine. But I really want to use the folowing code and I just can't get to work and that is really frustrating! Can anyone tell me why I can't get this to work? Other ADO code works just fine, just can't seem to...

I see, then maybe a little education is needed. Thank you

Hi - I have a linked database and occasionaly the ".laccdb" file is still being displayed after a weekend and I know no one has been into the system for several days. Why would this lock file still be displayed? I can delete it without a problem. I tested this scenario when I've had the database...

Thanks all - I learned some new things from your conversations.

Thank you for your reply - and yes, that works fine if the query isn't pulling values from the open form, but when you have criteria in the query that pulls the values from the open form, the open statement errors out.

Hello, I've searched quite a bit on this subject, and I never find an answer so I always revert back to keying in the sql statement into VBA and creating my ADO recordset. But, what I'd like to do is run the stored param query (it which works fine - it has one param and I entered the form's...

many thanks - I didn't think it would be that easy... :)

Hello - I'd like to clear a date field on the form via VBA. I thought that I could just say Me.EmailSentDate.Value = Null but that didn't work. After I find out how to clear the date, I hope to just save the row as shown below. I searched through a lot of books, but I guess this is so minor that...

Yes, that is what I am talking about...

Hi all, How does one suppress the info box displayed when the following code runs? I tried DoCmd.SetWarnings false without success. DoCmd.OutputTo acOutputReport, "rptEntireProjectSheet-Delay", acFormatPDF, strFileNameAndPath Thanks!

Hi - thanks, but that is basically what I did in the query... what I'd like to do is collapse the detail section when I don't have a value to print. Right now the spacing stays the same whether I am printing a detail line or not.:( Wait - I reread your comment and maybe I could use that, but...

Hi - I'm trying to skip printing the detail section when my data is empty. I thought it would be as easy as checking the field in the detail format section as shown below. I even tried to set the height of the row and field that I want to show. The me.delay text is evaluated and it goes into...

Hi - Does anyone know why sometimes the drop-down help would work in VBA and other times not? I do have the appropriate library references indicated. In VBA, if I enter Dim cnn as ADODB. as soon as I enter the period, the help should display but it doesn't always. Some times as soon as I...

You're on the right track - create a second form which will be your subform with all the fields (including the parent's key) in the query and save it. Then open the first form and drag the second form onto it. Since both queries will have the first form's ID, Access will know the link between...