Search results

Hi All, I've created a form in design view with a number of controls: buttons, test boxes, ect... Wherever I try to to view it in form mode the form comes up but none of the controls are viable. All are set to visable in the properties of each control. Has anyone camae accross thsi...

Hi All, I have an mdb, which complies without problem. I ran the security wizard on the mdb and try to compile it to an MDE and it pops up with an error. the error message is "User-defined type is not defined" as applies to the following code : Anyone know what the cause of this is ? -...

Hi All, Here's my problem... I have a DB (DB1) and a workgroup (WG1.mdw) and a bush of users with different levels of access . At the minute users have a shortcut set up on their desktops, which bring them though the workgroup and they sign in with username and password. Just wondering is...

Hi All, I have a report which has serveral record under details heading which should all be on one page. However on one computer the report prints with a new page for every detail. Any idea whats causing this ? - Elfman

Hi All, I have a table with starts with an autonumber as a primary key. Recently it has been giving out crazy high and sometimes negative numbers when a new record is created Dose any know what might cause this? p.s. I've tried compacting and repairing the DB - E|fmAn

Hi All, I'm having trouble with access. Basically it has been very slow to load (over 30 seconds when not opening a database) and when opening a database it just crashes. Has anyone any idea what could cause this as it worked fine before ? also would a reinstall help ?? -Elfman

HI All, My Problem: - I have a qry made up of 2 tables - 1 of the tables has an autonumber primary key - a made a form from this qry - It all works fine except that when I go to add new record it dosen't assign a new number for this filed and i get an "invalid use of null" error any...

Hi all, I'm having a bit of trouble with references. Several databases on my local network have begun to continually have trouble with he excel object reference. Whenever one of these databases s started up I have to go to debug menu to refresh eh reference. Can any tell me why this is and...

Hi All, I have an Access DB, which keeps having a problem with resources. When I go in and refresh the resource, it works fine.. For a while then same problem comes up again. I've had to refresh the references several times this week. Is this down to a bigger problem? - Elfman

Hi All, Here's what I've got so far: - A form with several combo boxes with filed that the suer can choose to filter a report by. - Each Combo Box has a button beside it with has the code behind it. - I have managed to get the code the work for some but it won't for other Example ...

Here's what I currently have: - A table with a number of fields about a course - A course commence date - A number of days the course will take field - No course end date Is there a way to easy add one field to the other to: Give end date i.e. do I need to write the code to validate all...

Hi All, I wanted to create 3 groups for a db, which is on a network and access by several people. I have been able to create groups and users and assign rights but they seem to be related to my instance of access not the DB as I’m asked for a password for all db's now. How can I associate...

I tried to explain this before and i didn't do such a great job so after a little more investigation I’ll have another stab at it: 3 forms A, B, and C derived from 3 tables tbl A, tbl B, and tbl C. tbl A : 1 <--> many : tbl B :1< --> many : many tbl C Frm C embedded in Frm B embedded in...

OK here’s the deal : Three forms: Form A from Tbl A Form B from Tbl B Form C form Tbl C Form C is embedded in Form B. Form B is in turn Embedded in Form A. Relationships: Tbl A has a one to many link to Tbl B Tbl B has a one to many link to Tbl C. Ok so my form is set up with all...

Hi All, Here’s my problem: User wants to see leading zeros in firm field when adding a new record but access keeps deleting them. I know it makes no difference if there recorded just wondering for the user’s happiness (and mine) can it be displayed on form?? Thanks in advance -Elfman

HI All, Can anyone tell me is there a way to stop access automatically deleting 00's from the front of numebrs after they've been entered into a form. I need to keep the 00's to ensure to different DB's match. All help aprciated -Elfman