Search results

Hello all, is there a way to change an ODBC connection in MS Access. I have 4 ODBC connections that I can choose from (all of them from the same server), and instead of manually recreating a new ODBC connection everytime, I would like to point it to the new connection. The ODBC connections...

Does anyone know how to activate a script editor in MS Access? I have done this with excel, word, power point, etc, but am unable to do this in Access. Thanks

Hello all, I have some VB code that I am working with that reads a text file. The code reads the text file perfectly, however, how can I tell the code to import the data on the next line? Here is an example what I have so far: If (UCase(Mid(strRecord, 1, 8)) = "Security") Then...

Hello all, I have a field name called check_date; I am trying to get a date range of 12/10/2006 and 12/14/2006. I was using between [Enter Date1] and [Enter Date2]. However, I need to get a date from 60 days ago (I am using now()-60 to get this) and use that date against the query. Is there...

How can I count the number of times an employee shows up on a report. The final result would be: Employee 1: Reader1 Employee 1: Reader2 Employee 1: Reader3 Employee 1: Reader4 If an employee shows on a report 4 times, I need it to look like the example above in sequential order, not just a...

Makes sense......thanks for your help. I was trying to put it at the end of my SQL.

How can I tell Crystal to pull records that have data in the field (is not null)? I am pretty new to crystal and have been trying to put the criteria in the selection expert fields. Is this correct? thanks for your help.

Does anyone know how to accomplish this?

Hello all, is there a way via code to refresh a MS Access linked excel spreadsheet? Otherwise, I would have to have the user refresh it (which I would rather not do). Thanks for your help.

I have a query that I need to add trailing spaces to. I have a query that pulls the first and last name of our employees, but after the initial text, I need to add spaces up to 20. So the text of the first name plus spaces would be 20 characters and the last name in a different field would be...

Does anyone know how I can capture the elapsed time of a query?

Nevermind, I found out what my problem was. I needed to set the code in order of the way the document read. Thanx

Hello All, I was hoping that someone could help me with a problem I am having. I am trying to parse and import 4 pieces of information from a text document. I can import 2 pieces of data, but when I try to bring in all 4, it bombs. Thanx in advance for your help. Here is a sample...

RuralGuy.......didn't think of that. Thanks for your help.

Thanks RuralGuy.... I can achieve a message by displaying the code below..................this is after I have imported my information into the database. The information that I am importing is numbers. I can count the records using the code below, but I really need the sum of the numbers that...

Hello All, Does anyone know how to display a queries result in a message box?

Brianwarnock Thanks again for your reply. I wanted to get both aspects of code and a Query, thus that is why I posted in both places. Thanks again.

MStef, Actually, I have a quick question for you. Is there anyway that the code can be modified to update the table that already has account numbers in it? I was hopeing not to have to retype all the account numbers. Thanx again.

Thanks Brianwarnock, I will work on this to see if I can get it to work. Thanks for all your help.

MStef, thanks.........this is exactly what I was looking for.