Search results

I figured I was going to have to do a recordset. Here is the code I am using: Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("Select * from [fleet assignment]") DoCmd.GoToRecord , , acFirst Do Until rst.EOF If [damage] = True Then DoCmd.RunSQL "sql" End If If [accident] =...

I have a continous form, in the OnClose property I have SQL code which runs an update where certain fields match. It works perfectly, except it only runs for the top/current record. How do you make it run for all records displayed? I am thinking that I need to create a recordset and work...

The problem is its only one field. The one field has over 6500+ characters without any consistent method for determining paragraphs.

Ok, Is this even possible? I have a report where the detail section in one text box. The control source is set to a memo field. The field contains 6500+ characters broken up into paragraphs. What I want is on print of the report, to search the field and where ever there is a blank line to...

Sorry for not responding as quick as you would like. Why can't you just import the the excel data into a table? For instance, create a command button or macro then code in transferspreadsheet. ADDENDUM: Wierd I posted before your second post had come up. As soon as I posted then yours...

Nevermind, just spent some time and figured it out. =Format(([text41]+[text42]+[text43]+[text44])*24,"#.0" & " Hours") Now that is good naming convention. :D Also this procedure works as well. Function DaysHoursMinutes (Interval) Dim Days As Long, Remainder As Double Days =...

I posted this in general a time ago and the issue did not get resolved. Here is the info: I have a multiple fields where the mechanics input their labor amount. They enter this in standard time format. I need to be able to add this time up and give a total of labor. I made the field in the...

BUMP.. Max I never received the DB. Can you try again? Or if anybody else has any ideas?

Hey Rich why don't you take a look at his file and see what you can do.

VTX sorry for the delay. I am actually down in Texas instead of AZ at the moment. My brother-in-law and I looked at it and figured out the issue. For each combo box that you have put this in the afterupdate property: docmd.save me.refresh This will change the other data without issues. I...

Right you would. I will look at your file on friday. I have travelled back to visit my folks and the computer they have doesn't have access. From what you are saying, it would appear that access is committing the first choice to that field, so on update the original value is still locked in...

or docmd.gotcontrol [text182]

Instead of import can you export? Just an idea.

I think everything is working for you from your last post. If it is not please clarify. If it is, GREAT, I am glad I was able to assist. If you have any more questions, please post them. There are many talented people on these forums. Good Luck!

Ok reviewed what you wrote: 1. To show the description instead of numbers change the order in your SQL statement. ex. 2. When you do this, in that combo boxes properties make sure you set the bound column property to 2 if the id is in the 2nd position. Meaning, the order that you put your...

Here is a sample database I just made with your nomencalture. Sorry I just saw your third post. Anyway this works. Make sure that the bound column porperty is set to the column that has the data that you are trying to match. Take a look it should answer your q's.

see table forum for reply.

If the frontend is going to reside on the web then both the front end and the backend have to reside on the same server. This is my understanding at least. Because the path to the backend has to be that, a path not an url. Frontends require you to be able to link the tables. Henceforth, if...

Yes, Make sure that table/query is selected then in the row source put the SQL.

You know I had tried that, but I wrote the input mask like this: 00:00; Can you do: hh:mm; If you could I bet that would work. UPDATE: Nope just tried it. The problem with number field then they can enter 99. well obviously there aren't 99 minutes in an hour. I have been trying through...