Search results

Hey guys. Thanks for the help, that worked. Unfortunately, this didn't solve my long-term problem of improving query performance, but it did get the query to work. When I use the language Access comes up with on its own, the query is extremely complicated, and I think it's causing the query...

Can someone tell me where I might be going wrong here. The following query works in SQL, but somewhere in the LEFT JOINS area, Access gets a little confused and says I'm missing an operator. SELECT Tariffs.TariffCPUCID, Tariffs.TariffID, AdviceLetters.ALCPUCID, Tariffs.ALID...

modest, Sorry, I didn't realize you were the hall monitor. Who says I didn't do a search? I've been on here 6 months, programming my database every day, and have asked only about a dozen questions. Perhaps I didn't find anything this time because I didn't come out of the womb knowing that...

I need to do a simple check to see if a file exists. Ie - If C:Myfile.doc exists Then a else b end if The reason I need this is I'm creating an XML file, but the script I'm using only appends to the end of the file, rather than overwriting it. FYI, the script is: Set fl = New...

You're right it's not SQL. I thought it was, because all of this was working right before I moved the tables to SQL, and with the autonumber being assigned at the end, I thought it was another change like that. In the interests of being thorough, I have done quite a bit of troubleshooting and...

IgorB, Thanks for the suggestion. I found some other things in there that help me, but it still doesn't fix this problem. I think it's to do with SQL, because it seems to work fine with Access tables.

I'm having a little bit of trouble following your question, but I'll try. First, when you pull up a query, you can edit it straight from the screen. If that query is based on a table and you have set up your relationships, you should be able to just type in the missing information and it will...

I am running an Access interface to a SQL server. When I run a macro or code, the form saves the current record and moves to a new line. Any idea why this is happening or how to work around it?

Rather than a Data Access Page, how about making a report and use VB to automate export to an HTML page?

Posted this over here since I thought the answer might require VB: I know that I can hide the duplicates in my report, but I really need to change the text of the duplicate to say something else. Right now I have a text box in my report set to: =[Name] & " - " & [Description] I would like the...

I know that I can hide the duplicates in my report, but I really need to change the text of the duplicate to say something else. Right now I have a text box in my report set to: =[Name] & " - " & [Description] I would like the duplicates to look something like: =[Name] & " (Cont.)" Anyway to...

Thanks, I was trying to go straight from text to Date/Time.

Sorry about that. I wasn't getting a resposne after several minutes, so I hit "Stop" and retried.

I have a spreadsheet in Excel, which automatically converted all of my text dates to serial dates (01/01/2001 to 36526) and stores the information this way reguardless of how I format it. I am trying to import this into Access and it won't recognize my dates as being dates. How can I get this...

I have a spreadsheet in Excel, which automatically converted all of my text dates to serial dates (01/01/2001 to 36526) and stores the information this way reguardless of how I format it. I am trying to import this into Access and it won't recognize my dates as being dates. How can I get this...

Double Thanks. BTW, why is SendKeys bad?

It's hard for me to say without seeing it, but this is what I would try based on the tables and queries you listed. =DLookUp("[Company]","Client Lookup Query","[Client]=" & Forms![OrderID]![txtClientID]) In order for this to work, you would need your form to be called OrderID, and you'll need...

Excellent! Thanks!

Perhaps your brackets are wrong. Try: =DLookUp("[Company]","Client Lookup Query","[Client]=" & Company) You may also need to specify the form with something like: =DLookUp("[Company]","Client Lookup Query","[Client]=" & Forms![FormName]![Company])

I have several fields with text boxes and input masks. When a user clicks in these fields, it puts them in whatever position in the text box they click in. If they click to the far right, it takes them to the right position and doesn't let them type the entire date, formula, etc. Any way to...