Search results

John A I'm still using 97, could you post it in 97, I can't open it. Would be greatly appreciated.

I have a combobox named: Champion the control source is EmailChamptionID, based on SQL statement SELECT tblChampions.EmailChamptionID, tblChampions.Champions, tblChampions.cemailaddress FROM tblChampions; I want the user to be able to select the persons name from the box, which has an email...

I have a form with a field called champion. I need when a user hits a command button, who ever name on the champion textbox to get an email message. I made the champion field a combobox with a rowsource to a lookup table, tblCorpChampions. tblCorpChampions contains the champion names and their...

what is rogue LD?

I have a database that will not compact (using 97) the error message I get is the microsoft jet engine stopped the process because you and another user are attempting to change the data at the same time. I copied this database on my desk top, and absolutely no one is using it. I can 'repair"...

Worked like a charm

I have an existing database, in whichi I've been asked to implement a counter, of sorts, which could count a store the number of times the database has been opened (including reports being viewed) , in a month. (I'm using access 97). Can this be done? How would I accomplish this?

Can this be done? I have a field called plant, which stores a F, C, G, B or China. Now I have to create reports, and I have to show what the plant is. (F,C,G,B are unacceptable) Other than going back in at the table and fixing how I have these values store, I thought I would use an IFF...

I have 6 combo boxes on a form, which call a report based on a query. The idea is that the user can query data 6 different way. How do I/ or the user know which one is actually running first. Would the order left to right make a difference? (None have sort ascending or descending)

thanks, but what is TOP 5 predicate (I'm using Access 97)

I have a report in which I only want the last 5 records to display, for instances there way be 100, how can this be accomplilshed? I'm using a parameter query, I"ve been playing with Min / Max / First / Last and help, isn't much help

I have a report with field plant. The Field holds C incidating Chesterfield, F represents France, G represents Georgia. Problem is on my report, I don't want it to display F, C or G, I want it spelled out. I need all three iff on one line, but I can't even get one to work. the control source on...

any other ideas? I can't run an update query on the existing 56K records, as a field was added indicating process, which I don't know, therefore I can't create the validation at the table level. I've tried playing around w/lines such as f Me.Frame48 = 0 And IsNull Then MsgBox "You must select...

Forgot to mention the form is continous, this probably matters.

I have an option group, with two options buttons. I need to to be a required field. (I cant) make this required at the table level, as there are already 56K records). I've tried on the before update on the form, making the frame tag = required. For some reason this is not working. Any idea's...

Help! One field in one record is corrupted. The text in the field changed to a #Error. When I click in the field I get a The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. I figured if I compacted it that...

I'm using the following code, has worked fine on the beforeupdate on a forms control. Problem is I'm trying to use this as validation on a command button. When the command button is selected I want the code to go through and validate the fields in which the tag property is set at "required"...

I have a calendar control which opens a report PPAPCompleteRequests. If there are no records to display, on no data I have the following: MsgBox "No records to display, try another date range!" cancel = true This works great, but now I have to print another report PPAPCompleteNONE. I added the...

Can this be done? I would like to create a database with links to 10 or so other databases. It doesn't look like this can be done with the switchboard, so I tried a command button and I get an error? has anyone done this? I'm mearly trying to organize an interface for users to many databases.

Every time I open a database, no matter than I've opened it before, it asks opening bla\bla\bla.mbd maybe harmful to your computer. Is there some way to stop that message? I went searching around in tools customize and nothing.