Recent content by U226RM2

No to both.

She is able to save to the folder independently of the database.

Thanks but I don't think this is the problem, it works on everyone else's machines and it worked for her on MOnday.

It isn't, everything before \Microbiology is mapped to F.

Thanks, the drive is mapped to the correct letter on the laptop (and it worked for her on Monday). No idea of the code but here is the first part of the macro in design view.

Hello all I have a macro set up which exports items from a query into an excel spreadsheet so it can be emailed easily. One of my colleagues was able to do this on Monday, but since then she has been getting an error message 2302 and it won't export the data. (The macro works on her desktop...

How annoying (did you like the way I managed not to swear?)! Sorry, I can't post my db as it has sensitive data on it. I guess I'll have to forget all about this particular crosstab.

Yes, the select query works fine but the crosstab gives the error.

The original query works fine. I have substituted [start date] and [end date] with actual dates and now the message is "Data type mismatch in criteria expression"

Hi Rabbie This is the query my xtab is based on: SELECT [Master Table deduplicated].[Lab Nos], [Master Table deduplicated].Source, [Master Table deduplicated].[Infection acquired], [Master Table deduplicated].[Source of bacteraemia], [Master Table deduplicated].Specialty, [Master Table...

Hi Everyone I am trying to create a crosstab query that is based on another query with a date range in its criteria. Crosstab doesn't seem to like it but I really need to be able to use data from a particular date. Any ideas? :confused:

Hi, can anyone help? I have set up a query that looks at a list box on a form for one of its criteria and then a text box on the form for the user to also specify a date. A command button on the form runs the query. Is there any way for the query to work if the date field is unpopulated (as...

Ha ha Helpful and funny! Thanks guys, problem solved and a laugh this morning. Is everyone on the forum like this or did I just get lucky with my first thread?!

Hey sorted! RG, I was just about to post a reply saying I just sorted it by checking the format property in the table rather than the combo box. Thanks, thanks, thanks! Ken - OK, I was dumb but not that dumb!!:)

Any other suggestions?? Thanks RG. The format property is empty so I tried your other advice and redid the combo box to look up data from a query - the combo box is still blank! (The query works on its own though)