Search results

I have never seen Access do this before today. I've been working on this database for months - it was working fine just a couple of days ago. But today, Access has started closing completely after I open the VBA editor, make a change and close the editor. It's not a crash and there is no...

I'm still finding 0 rows to update, even though debug.print shows that the table is on the correct record. What is an alternative method to using OpenQuery? Any and all suggestions are welcome. Thanks Private Sub CmdJobComplete_Click() Dim dbs As DAO.Database Set dbs = CurrentDb Dim jobid As...

Thanks for your suggestion. I'm running into a little trouble getting the checkbox to update - maybe my query syntax is wrong. I still have warnings turned on so I can see if it is actually updating the row - so far, no luck. Here's the sql view for my saved update query: UPDATE [Input] SET...

Hi everyone, This is what I am trying to make happen: User enters data in [Input Table].[Evalby] field - in the After Update event, I open a form, asking the user to indicate whether the job is complete. If the user clicks the YES button, the job status update form opens and allows the user...

So - how can I hide the form, keep it open until the report is printed, then close the form?

Closing the form before printing the report was what was causing the problem - I didn't even think of that. Thanks, everybody.

I am using a form to pass a date range to a query and running a report based on that query. On the report, I have a calculated field to display the date range. Here's the control source: ="Date Range: " & [Forms]![NCRs by Technology]![TxtStartDate] & " to " & [Forms]![NCRs by...

Yes - I was just about to say that Pat's suggestion of the outer join seems to do the trick. I think I need to customize some fields names but that shouldn't be a problem. I am going to try a union query on the two crosstabs just to see what happens. Now I'm curious. Thanks to you and Pat...

Cool - thanks. Do I put the PIVOT statement at the end of each query or just at the end of the second one?

I tried the new query joined on vendor name - it only shows vendors that have ncrs. I need all the vendors, whether they have NCRS or not. I've not done a union query before - what would the SQL look like?

I have one crosstab query that generates these results: Vendor Total Jobs Jan Feb Mar Vendor A 1 1 Vendor B 12 6 6 Vendor C 7 2 2 3 Here's the SQL: TRANSFORM Count([Subcontractor jobs].[Job #]) AS [CountOfJob #] SELECT [Subcontractor jobs].[Vendor Name]...

Well - you were right. The ones that won't work are running 64-bit Access. So, if you would post that code you spoke of in your original post, I sure would appreciate it. Thanks!

oh - ok - I see what you mean. Let me check.

All the machines this is running on are 64-bit so that's not it. I'll look for missing references but there are not any error messages that point in that direction.

To facilitate the import of an Excel file, I am using a button on a form to open a Windows dialog to allow the user to select the file to import. Once they select the file and close that dialog, another button click actually does this import. This all works great except on two particular...

I'll give those a try. Thank you!

Why use make table? I don't really need to save this value past the point of generating the report.

Can you give me an example of the DoCmd syntax for referencing that variable?

To run this report I have, a form will open on which the user will select a start date and an end date, then enter a number that will be used in a calculation on the report. The control is unbound and the value is not stored in any table - it is used for calculation only and is determined by...

I got it to work with a subform. Never mind about the broader question - I've about got it.