Search results

It needs to be as current as possible as that spreadsheet is always being updated. Is it possible to do something programmatically to HAVE a second version of that Excel file available to Access? Perhaps have Access create a duplicate file and then delete it? Is that what you were referring to?

What do you mean by refreshing the link before using it? I tried re-linking the table in Access but that did not resolve the problem, unless you are talking about doing so programmatically every time, in which case I don't know how to do that. I haven't noticed any issues, with using the...

All of the PCs using the file are running Windows 7. I have the spreadsheet linked, rather than imported, because it is constantly changing and needs to be kept up-to-date. As far as replacing the Excel document with an Access one, that is not possible right now for several reasons that I...

Need to have linked table open in Excel for Access to work...? Hey guys and gals. Probably a n00b question here. I have a .accde file that pulls data from many sources, including a .xlsm file. This is on a shared network, and many people have that .xlsm file open at any given time, with the...

I could use this code instead: That simply, if I understand correctly, returns the number of records in the FixedRoutes query, but I am unsure as to how to set that equal to a variable.

Here ya go.

FixedRoutes is indeed a query that filters out "today's" shifts from another query which holds the entire week's worth of shifts, which itself is the result of combining one .CSV file with the shifts, with an Excel table that holds the vehicle assignments for those shifts.

Quite honestly, it would be a lot of work to remove all the confidential information. Not trying to be lazy, it would just take some time. It is the same 3061 error that popped up before the report would open. The reason I have it in the On Load event of the form is because while researching...

I get the same error, and it highlights the same line of code: Set rs = CurrentDb.OpenRecordset(strSQL) Might there be an alternative means of accomplishing what I want to do? I could probably get away with just counting the total number of records in the query, since there is a big enough...

Here you go. This is what runs when my Report is opened. The first little bit you can ignore - that has to do with setting the visibility of something on the report.

Thanks for your help. I have amended the original post with the entire block of code. I tried your suggestion but I still get the same error. I'm starting to think it isn't an error with the way the statement is written, but more an error related to the way in which I have implemented the...

Yeah, those parenthesis confuse me too. The original statement didn't have that many, but when I made a new query and put this statement in it to see if it would work, this was the "auto-corrected" statement that it spit back at me. As I said, it works fine as a stand-alone query in access, but...

I don't believe the semicolon is necessary, but I have tried it both with and without to no avail. I also moved the closed parens around with no success. I still get that error not matter what I do!

I'm having trouble trying to get one snippet of code to function properly, and end up with the error in the title of this thread. I would have thought it would be an error in the query statement, but if I create a new query using what I wrote, it works just fine and pulls that one record. So...

Thanks for the reply! You'll never believe it but I just figured this out last night, and it works like a charm! I'm still not sure why this method works, yet calling the URL in an embedded web object does not, but I don't care at this point!

So does anyone have any suggestions for this or have I pretty much come across something that's impossible to do? This is literally the last issue keeping me from presenting this whole project to the IT department where I work and starting to implement it!

Hey guys. Quick question. I was initially using the URLDownloadToFile function to download a .csv file from an employee scheduling website. Everything was working fine, but then we discovered that the URL I was using (provided by the site's tech support staff) did not include any as-of-yet...

Would it be possible for you to explain in a bit more detail exactly what you mean by a Make-Table Query? It sounds like you are suggesting I turn the Query into a table and use that data instead. That sound like it might work, but I'm not sure how to go about it. Thanks for the help!

Just as the title suggests, I've got a problem. I have a report with the record source based off of "SOURCEDATA." Then I've got a union query that merges two other queries, which themselves are based off of the "SOURCEDATA" query. So everything is based off of the same source. The report, when...

I'm a bit confused. Let me try to explain more clearly WHY I am confused and maybe you can set me straight: I have a "Bus Board" in Access, a screenshot of which is included here. You can see the overall formatting and the conditional formatting in effect. I have never worked with embedding...