Search results

LOL! Ive managed to get part of what i want to do working. Your right with the Catch22.. i can get a module to check whether a control is registered and if it isnt then i can automatically register it. However, the activeX control has to have been manually set up first using the Tools >...

hi, I have an ActiveX control which needs to be registered the first time a user opens the database on a machine. Is it possible to run a query/autoexec or similar on startup which informs the user if this particular ActiveX control isnt registered? Our company is undergoing an OS upgrade...

Lyndsey, Im guessin you want to save the record after you've validated it and made sure all entries are correct? make your form/fields unbound If so, have a save button and amend the following code to fit your fields and table source ' NOTE: DAO 3.6 code Dim db As Database Dim rs As...

how do you expect to build a front end interface by not using forms? :)

You have to set the criteria as the name of the combo box on the particular form. EG: you want your selection to be based on a combobox (cboFruit) on the form (FrmSelectFruit) which is based on the table (TblFruits) ! your query has to have tblFruits as the source The criteria in the fruits...

clarify what you mean when you say search? Forms can be based on Queries, which is what you should be using to 'search' the DB. You can enter criteria in Queries to narrow down 'Search' results. Then use the Query as the control source for your Form.

You can get a specific form to load when starting the DB by: going to Tools > Startup > Then choosing the form name you want to start the DB with. ------- Forms can be based on Queries, which is what you should be using to 'search' the DB. You can enter criteria in Queries to narrow down...

hi, I'm having major problems with my database in that the database has lost all its functionality overnight! If I click any button it gives me a message about indexes. (indexes1.jpg) i cant seem to view any tables, queries etc in the database view! (BlankDB.jpg) When i click a tab i get the...

Hi, Is it possible to count the number of consecutive days in a table? I need a query to calculate for a particular customer the number of consecutive days thay have logged a record if its greater than 1 EG: Table layout: CUST A RC1 05/05/05 CUST A RC2 06/05/05 CUST A...

Brilliant. Thanks for that Cant believe it was as easy as that. Bit embarassed i asked! :)

hi, I'm having a small but annoying problem exporting data to excel and then importing it back.. The problem is that when i export a table to Excel - it changes the date format from dd/mm/yy (which is what i have in Access) to DD-MMM-YY (automatically in Excel) This proves to be a problem...

A switchboard doesnt create seperate forms for each sub menu. Its always the same form but with the options available changing... This is the problem in that if i open the swicthboard it always refers to the main menu and not the sub menu i want it to refer to

Hi Guys, I've checked the search but cant seem to find any answers relating to my problem. Apologies if ive missed it. What i need to do seems fairly straightforward but unfortunately i dotn have the knowledge to pinpoint what has to be done. I have a switchboard with several sub...

Hi, I have a continous form with only 5 records. I am trying to update each record with one click on a save button. i am trying to do a loop so that it goes through each record using acnext but obviously it shows up with an error when i reach the end of a record set! is there any way to know...

i couldnt have a look at your example as i'm using ACC97 but: from your question - would it not be easier to use cascading combo boxes? (Search the forum) then on afetr update of your country combo box: Private Sub cboCountry_AfterUpdate() ' check whether the Country box has a value If...

My Access database is situated in a folder which has permissions to only let some people write into it. The problem is that we would like users with read access to open the database to view but get the following error: Couldnt use ...path... File already in use. The database always has more...

Thanks for that. I'll have to check that out with our GIS.

Hi, I have built a form without a record source as i need to mess around with the fields before i save. On save, i would like the form to save to an ODBC linked table in my database. I save the record through a save button which has the following code attached to its on_Click event. '...

It definately exists. Ive been using it freely but been having problems with some users wher it doesnt recognise the funtion and returns #name? in the field. im not sure whether it has to be reference to a specific library for it to work or not?

Hi, Does anyone know which library in MS Access 97 is required to make the environ function work?