Recent content by Elfman

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 . that didn't do the trick still have to refresh references everytime it's opened.

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

Oh wait cancel that seems to have done it but now it's telling me hummmmm don't like this DB By the way thanks for all your help on the other error message

Still no luck I'm afraid still saying syntax error. Quick Q do i need any special setup on my form to pass parameters ??

Well I changed the col count to one cos that’s all I have still same problem. I tried putting the & "" at the end but no good I'm afraid, The actual error message says and finds the right name

It's set up as col count = 2 Name and CboName are def right. mmm a bit stumped am I

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