Search results for query: *

I am having an issue with implimenting specific security in a database. The requirement is that when a form loads, a function is called. This function runs through all the controls on the form and sets them to disabled based on information held in a user security table. The calling form passes...

Hi All, Can't find the answer for this one but it is probably staring me in the face! We are re-writing an application from Access 97 to Access 2003. The front end is access and the back end is SQL Server. In the '97 version we create pass-though queries as the recordsource for our forms, use...

When I type in a command that would bring up the list box of available arguments, the list box disappears automatically. Also when you press space bar the space disappears. Anyone else come accross this before?

I have an access 2K database running in access xp. Recently, the database has decided to ignore any breakpoints I enter when trying to step through code. Has anyone seen this before?

When trying to open a recordset I keep on getting @Run-time error '13' Type mismatch error. Code is very simple: Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = db.OpenRecordset ("test", dbOpenSnapshot) The @test@ query opens fine in the database window.

How can I get a page total prior to reaching end of group? I have a report that has three pages of detail. One page one I need a total for "inv_val" field in the page footer. On page I need to show the total in the page footer but only relating to details printed on page two etc...

Does anyone know of a function that will display a numeric value as english text e.g: €3,417.98 Should result in: "Three thousand, four hundred and seventeen euro, ninty eight cent". Thanks for your help.

This has happened to me a number of times on different workstations. Has anyone out there any suggestions. When typing in code in a module, two things happen. When you hit the space bar the cursor automatically moves back to the left unless you type within a second or two. The text is also...

My database has reached 1 gig. This happens during an import routine. I know that after I compact that the size will reduce to 450MB. Is there a way of incresing the maximum size limit of an access '97 database ?

Does anyone have experience of outputting access reports for distribution in pdf format and what is involved ?

I have a query that runs on a large number of records. Midway theough the execution I get a system message saying that access can't undo the effect of this action query due to disk space or memory constraints. Disk space is fine so it must be memory. I know that I will not want to undo changes...

Hi All. I have a text box in general date format on a form (19/02/01 23:32:00). When I click a command button on this form, this sets the value of a variabel "timetorun". The code basically loops until now()>timetorun and then it runs a number of macros. This all works fine. My problem...

Easy to do in vba but trying to do in macro. I have a macro that runs a number of action queries. At the end I have a message box. I want the message box to display text and read a value in a text box from a control i.e. : "Figures generated for" & " " &...

I have a simple crosstab query. I need the column headings to be fixed. I have typed these into the column headings property of the field in the query. My question is that I would like the column headings to be read from a table rather than hardcoded into the query as the number of column...

I have a table where the key field is an autonumber datatype. Imagine there are five records and someone inadvertantly deleted record number 3. Thus I have records 1,2,4 and 5. Obviously I can't re-enter the deleted record because it would be assigned a number 6. Is ther anyway that I can insert...

Hi Guys, Should be a simple question. I would like a command button that sets up an e-mail to a soecified address and automatically attaches a number of pre-determined .txt files. Thanks in advance

Table in access 97 will not open after p.c. crashed. error is invalid data type (error 3259). Database will not compact/repair. Can't open or export offending table. Any ideas?

Hi All, I'm trying to amend a table in access 2000. It has roughly 140 fields in it. A lot of them are lookups to another table e.g. cargo1, cargo2 etc.. I need to add another 20 of these fields but it is comming up with an error: "Property value is too large". I don't think I have...

After I change the domain of our NT server, SQL Server won't restart. The follwing message comes up: Initconfig: error 2. The system cannot find the file specified opening master.dat for config information,

Problem is on one table. Form is based on a single table query (select *). For presentation purposes, some of the memo fields are in other forms. Forma are linked by ID_no. Command button to look at memo form from main form. If record is edited in main form and then memo entry is edited in...