Search results

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...

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...

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...

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...

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...

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. '...

i have a menu which recognises a user by using the environ function. the problem i am getting is that with a small number of users the environ function isnt recognised by the system? it gives them a #name# instead. the crazy thing is that it also happens on simpler functions such as =Now()...

hi, I have a couple of queries which churn out some sales figures based on customer. The output query is descended by sales - so presumably the highest sales are at the top. However - the query is oddly sorting by the first digit only making the results appear in a odd order. e.g. 90 is...

Hi, Need some help with a query im working on please! At our company, we record a customers name with a date every time a particular event occurs. I need to find out the difference between 2 dates for a customer and present the number of days. The two dates to be subtracted are the most...

Hi, I have a macro which runs when my database is opened. basically, the macro runs several querys to create a new table. The problem is that i only need the macro to run once a day - so for only the first person who opens the database that day. At the moment, everytime the database is...

Hi All, Ive searched the forums for a couple of days now trying different solutions to my problem but cant seem to figure it out.. im trying to find out which users are currently logged in to my database and then send them all a message. I've got as far as sending a message within access to...

hi all, is it possible for me to prompt a user to connect to a database as soon as they open my Access Application? my access app uses linked tables and the user is prompted for a password and username one they enter a form that requires linked data. it only asks the user to enter the password...

hi, Is it possible to password Protect a table in Access 97? I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how. any ideas?

Is it possible to format fields conditionally in access 97? I am trying to change the font colour and font weight based on the value in the field? Thanks in Advance

How would i go about giving a user friendly message to the user if a new record they were inputting already existed? Thanks in advance

Hi all, I have a data entry form where users enter figures to 3 decimal places. eg A = 1.435 B = 2.650 This gets saved as a record to a table. I then create reports based on the table. However, Ive noticed that when i run the query the system seems to add random digits on to the end of...

hi all, i am trying to build a graph from a query based on data per Week. i.e. 52 columns of data. The graph works... BUT the data table on the graph randomly misses out columns because they wont fit! is there any way to correct this? thanks in advance

I have a crosstab query which has the week number as the row heading (Week 1 to 53) The problem is that if i try to sort by Week then this is how it appears... 1 10 11 12 ... 19 2 20 21 ... and so on.. anyone knw how to fix this??