I am creating an order processing system and am using 2 tables
OrderHeader
OrderLines
The OrderHeader table includes the number of orderlines on the order.
I want to ensure that when a user completes the order lines they don't up in a line number greater than the number of lines and want to programatically get the number of lines from the order header table.
The form links to the ID of the order header table by using a combo box, which works fine and I can even display the number of order lines in the combo box.
I don't know how to use an ADODB recordset to query the current database.
I can't use something like :
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:filesdatabase.mdb"
which i see all over the place, because I don't know where on the PC this will be running on it will be stored.
There must be a simple way to find out a value from a field within a recordset of the current application database?
I would like to create the following functionality on a form in my database:
When the form is open, and a record is displayed on the screen, I want to add a button that will open up a second form displaying information related to that record.
To be specific, I have a form called "Contracts". Each contract record contains a customer name in the field "Customers." I want to create a button labeled "Customer Details" that will open a new form, "ViewCustomers" displaying the record associated with the value entered in the "Customers" field for the current (displayed) record only.
I have been trying to use a hyperlink to a macro that uses "OpenForm," form name "ViewCustomers," but I don't know how to filter it down to just the current record.
I hope any of this makes sense. Any insight would be really helpful.
I am trying to run a macro on doubleclick in a subform (dataview) that will open the same record in a popup form (tabular).
I've enter in the macro Where Condition the following statement to only show the record I doubleclicked on in the popup. The only problem is it's asking me for a parameter value for the LogID. Its apparently not picking up the LogID I doubleclicked on. Is there any way I can fine-tune this WHere statement so that it knows the record LogID I clicked on. (The pop up form should show only the same record).
I have a main form (ZooMobile Booking Form-New Client) with a subform (ZooMobile Event Booking-New Client) within it. In the main form I have a button to open up a report displaying the main form's current record.
The report that is opened has a subreport that needs to display the current record from the subform.
So far I've managed to get the report to open to the main form's record using the following On_click command:
I can't manage to get the subreport to open to the current record in the subform, however. I've tried to integrate it into the above event and to use On_load events in the report and subreport but everything either comes up as a bug or has no effect on the subreport's record.
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application Call AcApl.OpenCurrentDatabase(strfolder, True) Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
I am using Access 2010 - Version 14.0.61.29.5000 (32-bit)
I am building a custom Export Wizard to export data to Excel using the Report Wizard for the basic ideas.
All I am trying to do is have a [Back] button on a form to open another form and close the current form.
Private Sub cmdBack_Click() DoCmd.OpenForm "frm_ExportWizardPage2", , , , , , Nz(Me.OpenArgs) DoCmd.Close acForm, "frm_ExportWizardPage3" End Sub
The new form is opening but then the current form is not closing. All forms are the same size, shape and positioned centrally although this should not make any difference.
Could this be anything to do with which form has the focus when I open the new form?
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?
The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob
I have a question. I have a button on a form. When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database Dim rsMyRS As Recordset Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb") Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.
I tried that database on 3 different PC's with the same effect.
Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.
My database is opening much slower than normal just over the past few days. When I run a performance analyzer it is telling me that my database is only being compiled in a partial state. How did this happen and what do I do to fix it??
I am hoping someone out there will be able to help me figure this one out! I have a database I just created which houses approximately data on about 500 physicians/practitioners - from their personal info to information regarding their licensures, liability coverage, and DEA. In order for us to be compliant with administration and government criteria we have to monitor expirations of their license, liability, DEA, and other things. We do this by sending letters/e-mails out 30 days in advance of expiration dates (which is a field in my database). What would really be great if when I bring up my database it would automatically give me a pop-up saying these licensures are expiring in 30 days and send out reminders. I am a rather new user to Access but I do recall a few years ago hearing something about databases that have crystal reports??? I am not sure if that is the same thing or not. I do have parameter queries set up from date to date but it sure would be impressive if I could get it to do the above. Or maybe another way to do this. Any suggestions????????? CMElady in :confused: distress!!! Thanks.
ive just upgraded our sales database from access 97 to access 2002. everything is fine apart from when i try to open the database twice on one machine - it wont allow this. In access 97 this was allowed and i normally had atleast 3 databases (all the same database) open at once.
I tried to search the forums for an answer but I still can't seem to solve the problem. I receive the "Not a valid bookmark" error message when attempting to open my database. I have tried the compact tool through access and also jetcomp but it just brings up the same error message on access and says "error compacting database" on jetcomp. Can anyone provide a solution to my problem in order that i can either open the database or else retrieve data from it? Many thanks, any help appreciated Jon.
I have attached the database in case you have any software which might be of use.
I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
I'm trying to create a log in form for my database using a tutorial I found here. [URL] ..... I got it working fine, but when I split my database into a front end and back end file I could no longer retrieve the record set for this code. I receive the error "Item not found in this collection" on the highlighted line of code below. I'm at a loss as to how I would retrieve the record set with a split end database. The code used in the log on button is below:
Private Sub submitButton_Click() Dim dbs As Database Dim rstUserPwd As Recordset Dim bFoundMatch As Boolean Set dbs = CurrentDb
I maintain an Access 97 database system with a number of front ends and two different back ends (for security reasons). The structure is replicated in different directories as there are training, development and back-up copies as well as the live system. I want the menu page to display the name of the front end that is opened and the path and name of the two back ends, referenced from the current database (front end). To do this, I want to read the directory for the current database as opposed to the current directory which may be different. I can't find this in any VBA reference for MS Access 97; although I used to use the equivalent in Excel using the Get function - as I remember it.
I was wondering if anybody knew a way to disable the security warning in Access that pops up saying "This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"
If possible, I'd like to disable the message for just my database, but we currently don't use any other database anyway, so I'm not too concerned with turning it off completely if that's all I can do. I'm sure there has to be an option somewhere to not check for macros or something, but I can't find it.
If anyone knows how to do this or if you know that it is not possible, please let me know.
We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have no idea how it was set up. I think it may have something to do with being opened up exclusively. Is there anyway around this by creating a short cut or changing any kind of propertties?
Got something which has been bugging me like mad for weeks now;
We have a MS Access Database on a Citrix server and a local copy is downloaded to the clients directory when they log on.
When they actually double click and load the database(frontend) it loads for approx 4/5mins before it eventually opens. After that it is fine, unless they log off and back on again, then the same thing happens when they double click to open the database.
The Backend is stored on a seperate server with over 5million records on it.
Before we attempted Citrix we had a normal network and the frontend has always loaded fine on this.
I recently found a need to pass a message on to everyone that opened a certain access database. So in I thought the easiest way of doing this would be to use the startup page & macro on the Northwinds Sample Database that comes with access.
However, I kept getting an error because the ok button was pointing the main switchboard which doesnt exist on my database, so I tried deleting the following to see if it would sort the problem: -
' Closes Startup form. ' Used in OnClick property of OK command button on Startup form. DoCmd.Close DoCmd.OpenForm ("Main Switchboard")
Now I think I've made things a whole lot worse. When I opne the database I get that first startup form and of course the button doesnt work and everything else is disabled.
I could really do with some help on this one.
Thanks,
Marc.
P.s. Cracking forum guys, if it weren't for places like this people like me would be in a whole world of ****!!
