Search results

Is there anyway you can work (develop) an Access db at the same time, otherwise you get open for exclusive mode by the first person in. There are 2 of us and we want to work on things at the same time, how can this be done. Thanks, Olie

I have a database that will be accessed by multiple users at one time, will I need to setup Users/Groups in MS Access for them to be able to work normally? Security is not an issue - as I have LAN security etc... I just want to know if they will be able to use it without a username and password...

I have this Access database that had no documentation (i.e no blueprints to the building). We want to expand it further and I have no idea where to start in documenting it. I understand how some of it works and I have a clue about access, but there are so many Queries, Forms, and several tables...

I have been asked to make an existing DB available at 3 different sites. i was thinking would it make sense to set up this Access database as a client/server database. The actual DB would be in one location. To add/view data this would be available via however via asp/intranet IE browser & a...

***URGENT*** DIM DB Problem Can anybody tell me what to do about DIM DB: This is the code that will not run: ---CODE--- Private Sub CustomerOrderNum_AfterUpdate() On Error GoTo CustomerOrderNum_AfterUpdate_Err Const NO_CURRENT_REC_ERR = 3021 Dim ds As Recordset ** Dim DB...

I have this form that always open in a Maximised state. I would like it to be in the size I have made it and not fully maximised. Do I need to use the CanGrow function? or is there an option to stop the form from maximising? Thank you for your help, Olie

When I open my forms (mainly from the switchboard), they always maximise, however the forms are designed to a nice size and I have to resize them by clicking the restore button. How can I disable them from maximisign them when opening (as the look crap otherwise) lol. I want to stop them...

Also How do I remove the Grey Ugly things on the left (the verticle bar thing). I have completly forgotten how to do this. Thanks mate, Olie

How do I remove the blue title bar on my forms (I've forgotten lol). Thanks, Olie

I have just imported some maros into Access 2000 from 97. The macros basically establish the menus with the form being displayed. However these macros are holting (i.e not working). I am not quite sure what this means but the message says: 'A menu bar can only be run if the menu bar macro name...

the following code with (*) will not work, i am unsure of what to replace it with. ---CODE--- On Error GoTo glrVerifyAttachmentsErr Dim varReturn As Variant Dim strDBDir As String Dim strMsg As String *Dim db As Database Dim varFileName As Variant *Dim tdf As TableDef...

I have a client/server DB (I think lol). The DB is located on a mapped drive on a server (which is common amoungst all users). The security MDW is also located where the DB is. Each workstation is setup (I think) to access the MDW file. Users&PWs are located there. Some users DO NOT HAVE TO...

Hi, Could anyone tell me how to reset permissions on a database (I dont want the logon prompt to pop up). When I delete the MDW file I get told I dont have permission to access the db. All i want is for one user, with normal admin access (no pw). Thanks, Olie

I have this database which I have just managed to get into. However I cannot access any menus. I have tried the shift option when u open Access to get to the menu's, but I still only get a full screen startup form, which when closed will not show me the menus in access. Is this programmed in. I...

Does anyone have or know of any free full working (non-demo) password removal or revel for Access databases. I am locked out of a database!!! Help, Any suggestions or program etc.... Thanks! Olie

Hi, Does anybody know where I can find a password/security removal program (free/shareware) to remove a secured Access database. Basically the guy who programmed it so called 'hard programed it into the database' it also use's 2 databases and the one security point so both DB's check there for...

I am trying to add a print button to a slide so a user can print the current slide he/she is on (they cannot go to file>print), should I record a macro (how do i do this in Powerpoint - I only know Access macros), or do I use VBA?? Help!!! Thanks, P.S I am not a VB programmer so I dont know it...

I have written an expression to update a form's details. (quantity x price = total). What i want to do is once i have entered in the price or a particular field, it updates/runs the expression so it works out the total immediatly. Any suggestions? Thanks Olie

i wanted a calculated field in a subform. it needs to multiply a value in the subform by a value in the main form. Basically the currency field is multiplyed by the quantity to work out the total. I run a macro which closes the form and runs an update query (calculates the total in the relevent...

I have a form (which I want to make totally invisable in the background) however I cannot seem to do it. Can anyone help me? I am using: FormName.Visable = False in the form load property. Any suggestions. Thanks Olie