Search results for query: *

I have query that shows 3 columns, I want to be able to ID a change in one new column, each time it changes. Can anyone help me? I want the query to look at the prior record, the query is sorted on time, and if it changes I want the new column to display "change" if there is not a change then...

I am renaming a file using VB. I would like to attach the renamed file to an email, and emial to the same person each day. Can someone help me with the email part of this? Thank you. Here is my code to rename the file. Function FileRenameTri() Dim OldName As String Dim NewName As String Dim...

I have a query where I am formatting the date to mmmmyyyy, That formatted field is a grouping on my report that I want to sort by. The problem is it's sorting the by the alpha and not the date. How do I get it to sort by date? here is wht is currently looks like on the bad sort. April 2008...

Can someone help me please? I need to create an Oracle driver ODBC connection in VB. The plan is to call this function when the connection has not been installed on a PC. When called it will create a system DSN with and Oracle ODBC driver. Thanks.

I have two fields that I would like to find out the difference in minutes. Both fields are text. Is there a way to format the text to time and get the difference. Time1 Time2 0255 0300 I would like the result to be 5. Because they are text fields I am having an issue.

Can anyone help me please? I will like to email a query only if the record count is greater than zero. It can be a simple EXCEL attachment email. Either in code or maybe a conditional macro. thanks, Sean

I have a query that i would like to return the next date for that number. 1 is Sun, 2 is Mon and so on. So if I have a 5, then I want to return the Date of the next Thursday Tomorrow, 062107. 6 would return 062207 7 would return 062307 1 would return 062407 2 would return 062507 3 would return...

I have a table that has a pallet count column and a Sequence column. Can someone please help me create trailers but using decending sequence, with 26 pallets per trailer. Example, Below, the code should create a new route after 26 pallets or something close to 26. Pallets PickSeq Route 3 114 1 6...

I am trying to get all the characters to the left of a field up the the ".". In a query can anyone help. Example. 368. 17. 145678. Result 368 17 145978

I have a looping copy/paste macro that runs through a certain # of rows and a certain # of columns. I'd like to figure out how to know what column I am on and stop the macro at a specified column, ie: column "DZ" Since this macro is used on spreadsheets of varying lengths, I was planning on...

I have a looping copy/paste macro that runs through a certain # of rows and a certain # of columns. I'd like to figure out how to know what column I am on and stop the macro at a specified column, ie: column "DZ" Since this macro is used on spreadsheets of varying lengths, I was planning on...

I have a report that I would like to have a field [Store] in bold if the date is less than a week old. I can't seem to get this to work. Help please

I am running a query that is merging about 10 fields into one. I have a weight field that I need to format as 0000000.00, How can I do this? PLEASE.

Is there a way to copy a report, query to an outlook email? I don't want to attach it I want to put it on the body of the email. I'm using Access97 and Outlook2000. Sean

I have a table that has Division number then about 3, 4 or 5 nulls under it until the next divsion number. I want to take the division number and put it where the nulls are until the next division number. I want to continue this untill the last record of the table. Here is an example.. 100 Div...

I have a table that has Division number then about 3, 4 or 5 nulls under it until the next divsion number. I want to take the division number and put it where the nulls are until the next division number. I want to continue this untill the last record of the table. Here is an example.. 100 Div...

I have a table where the "-" sign is to the right od the number. I need to move the negative over to the left of the number, so I can make it a numberic field and do calculations. I would like to do it in a query, if it can't be done, then whatever works best. Please Help

Hello people, I don't if this is possible but I would like to use the Send object funcion to send a Zip file of an Excel spreadsheet. I am exporting the spreadsheet to a drive currently. The spreadsheet is too big to email, so I need to zip it before I email it. Can this be done? Sean

I would like a wave file to start when a form opens. Can anyone help? Thnx, Sean

Is there a way to update the "Last User" in the registry to the current NT user ID? The path in the registry is HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\Last User