Scenario - I have one main form containing all the customer details. From this I can open several other forms, containing various other information about the services that they have applied for, and the stage of their application.
Some of these forms also have forms that can be opened from within them, so there can be at times three tiers of forms.
When I add a new customer on the main form, I then open the second form, add more info, then choose from another selection of forms. So at this stage there are 3 forms open. The final form contains a command button to run a report.
However to get the report to work, I have to shut down the last two forms and re-open them, even if I refresh the data on all of the forms.
Is there any way I can create a command button on the final form that will synchronise the data on all of the forms that are open and make the report work first time? Is there a way of doing this using Macros?
I want to synchronise the data in the Sales subform so that, when a different record is clicked, the data in the subfrmSales2 changes.
IE, when a user clicks on OrderID1 in the Sales subform, then the data for OrderID1 shows in subfrmSales2. And when a user clicks on OrderID315 in the Sales subform, then the data for OrderID315 shows in subfrmSales2.
I need to some advise on which is the best course of action.
I have a MS database with an SQL back end as a client server application.
Now the next step is to give stand alone versions (with a mdb back end) to off-site laptop users, to make updates or entries when not connected to the office network. Hwr upon returning to the office or when connected on-line through a VPN connection, I would like the databases to synchronise.
I tried exploring the replication options in access but that doesn't seem to work.
What advise and or softwar tips could one offer me.
(ps .net web application is not an option yet as this means a complete revamp of the program, with no .net knowledge available yet)
I have today setup an Access database for work as we were using Excel but it has become far too hard to manage.
We receive a list of properties which are empty every month in an Excel spreadsheet. I've managed to import my first set (March) successfully into Access. The idea is that we'll supplement Access with investigation notes etc having one access record per property (each property has its own unique ref. number).
However, next month (April) I'm going to receive a new list of empty properties which will include some from the previous month and some new ones.
I want to import this into Access but tell Access:
- Not to import ones which are duplicated (as there will already be case notes on file). I presume it'll be able to check the unique reference number; - Insert non-duplicated entries (i.e. any new properties which have come on);
However, I also need to be able to identify those which are no longer empty and mark them as non-empty BUT not delete them (as we need the records on file).
That means that running a report in April will give me the same number of empty properties as the Excel spreadsheet.
Is there a way to do this (not manually as we're talking about 2,000 records per month!) or is it going to become too complicated for Access?
Hi I am trying to find the best way to synchronise several different versions of the one database, two of which are used by remote users so i can't really set one database on a central server, I am trying to come up with an as automated a process as possible as it will need to be done on a regular basis, has anyone any ideas??
it is a microsoft access 97 database
I will be updating it to a newer version as soon as possible
I have a database which I have replicated and I am trying to synchronise the replicated copy with the design master - both at the moment are stored on the same network share.
Whenever I try to sync from the replicated copy I get an error message saying the "search key was not found" and the database won't sync.
:o:confused: I'm desperately searching for a way to synchronise different copies of the same access 2003 database i created. I have tried brief case synchronisation, and I have also tried the replication manager that comes with access but they both haven't been much help. My experience with them leads me to believe that they both work best with a LAN or internet connection. I'm seeking a solution that will work without a LAN or internet connection. Something that will copy my tables and other required objects to a folder that i can copy and move to another pc where another copy of the database resides. It should then import the same tables and objects and hence synchronise the copy of the database. I recently saw a visual foxpro database that has the kind of synchronisation solution i'm looking for. I think it works this way;it exports all the tables and necessary objects to a folder that it creates allowing you to copy or move this folder via portable storage device to another computer. It then synchronises by importing the tables and other objects from this folder into the database resident on that computer. I think there might be a way to do this using macro's or VBA but alas my knowledge of these areas of access is very weak. Is there a way to recreate this functionality in access 2003 using VBA code?
I have a main form with combo box used for selection criteria. On the same form is a datasheet subform which show the records according to combo box criteria. I have also managed to insert (All) into the combo box to show all records but when I click "All" nothing happens. It does work for all other criteria in the combo box.
I attach the mdb so you can see what I have done so far. Can anyone help me on the matter. Thanks
I want to create a form that allows users to update multiple fields for multiple assets. Below is what I came up with:
Ideally, I'd like the subform to be filled in by having the user select multiple Assets from the S/N combobox field which would then auto-populate the "Type" field. Then they would fill out the appropriate fields they want edited in the top part of the form. They hit save and magic happens. This would also be nice because only assets they want edited would be displayed (easier on the eyes) and no distinguishing would be necessary. To do it this way, I know I would need to use a temp table but I wanna avoid using temp tables.
I know I can do this by adding a Yes/No field in the "Asset" table, setting the "Asset" table as the subform's recordsource, and then putting a checkbox in the subform and allowing them to check the assets that they want to edit (which would also allow me to sort it instantly so that checked Assets are at the top of the datasheet for easy viewing), but I would like to know if there's a way of accomplishing this without the use of checkboxes.
I know I could also use a listbox and that allows them to multi-select items, but I'm not sure if that allows me to group all selected items at the top of the listbox for easy viewing of selected items. Plus it would involve a lot of scrolling (there are over 2k assets).
I have a sub form that shows me a companies history. This subform is used on 2 different Parent forms. The record source for the sub form uses a criteria that looks at a companyID field on the parent to determine which records to return. My question is how do I have the query criteria depend on which form is currently opened? The criteria would look something like this:
[Forms]![frmCompanyHistory]![txtCompanyID] OR [Forms]![frmCompany_Project_Details]![txtCompanyID]
If I open the form with this criteria, I will be asked for a value in txtcompanyID for whatever parent form is not open. How do I properly do this without making multiple queries that are almost identical?
I have multiple sub forms and want to add specific text boxes of different sub forms into one another sub form. Then all sub forms are incorporated in one main unbound form.
I am a girl guide leader trying to make a faster way to keep track of my unit's completed badge and program work. I have made tables for every area I need (I started with one table but it was too large to change into a form).
In total I have:
- Basic Member table (main information like their name and how many years they have been in, whether they are still in the unit, etc) - Program area tables - Interest badge tables
What I want to do is be able to "add/edit" members from the main form, then go to all the sub forms for their program and badge work -- problem is, how to link them!
I have forms that are printed based on a query parameter of [enter item number]. There are several of these forms that I would like to print at one time (with one command) making it easier for the user to gather their information at the beginning of the day. I also don't want to lose the ability to print them out individually as we do now.
I want create combination of navigation forms, navigation forms with two horizontal level and vertical level that link to navigation buttons in second level of horizontal navigation.
I have a Main Form with 10 Buttons on the Left side (Right side of the Form is Blank. On Click the Main Forms Closes and respective Forms opens based on the button I Clicked.
Now over here I wish to Keep the MainForm OPEN and subsequently open the other Form on the Right Side in Blank area.
I've been trying to figure a way to minimize my code in a module. I currently have three function built excalty the same way to work with three different forms. Each textbox in all the forms are named the same now what I'm trying to do is have the function identify which form called the function and where should the data be.
Code: Dim frmCurrentForm As Form Set frmCurrentForm = Screen.ActiveFormMsgBox "Current form is " & frmCurrentForm.Name
Once that is found. have something like this.
Code: Select Case frmCurrentForm.Name Case 1 WorkForm = Form1
Case 2 WorkForm = Form2
End Code: WorkForm.NameField = "John Smith"
No matter if all three forms are open the data should only go to the one that declared the function.
hi i have a database set up with a table for monitoring registarations for seminars each attendee can attendee up to three seminars and as such i have three fields in this table (amoung other) SeminarId1, SeminarID2, SeminarID3. Each one of these has a one to many realationship with the primary key of the seminar table SeminarId. On the form i wish to have the name of the seminars apear next to each of these when the id is entered. This always works for me when the object is in one realationship yet i can only work out how to get one seminar textbox that shows the data of SeminarId1 (using the wizard) yet cannot work out how to do this for this situation. Thanks in advance Rowan
p.s is it also possible to restrict the amount of times a certain piece of data can be entered in a field (each seminar can only take 30 people) so it would be nice if after the field contains 30 entries for seminar 1 he input mask changed to no longer accept this value, i am confident with vb and am sure this would need to be done in code just wondering if there is an easier way.
Hi, very new to access and chucked in at the deep end. we require a database which will be used by multiple users to place orders. the users are at different locations although they all log on via terminal services so connection issues are minimal. i understand that we require a fe/be database because of the users. the users will only work with forms and reports. they should not be allowed to see the other users orders and the form needs to automatically put the users id into the order. the only way i can see to achieve this is to make a custom form up for each location. would i be right in assuming this? if so, how would i prevent one location from opening up another locations form? infact, i wouldn't want one location to know that there are other forms for other locations. any help would be appreciated. thanks
I'm sure this one has been asked time and time again!
I currently have a set of staff questionairres each on a different table. Currently when I want to export all the scores for one employee to excel (eventually) I have a macro which runs 7 queries, but each asks for the same criteria (Date To & From) and (Staff Name) in turn - very time consuming!
How do I create a query or macro which will ask once for a date range and an employee name and apply to all of my queries?
I am a novice on access and am trying to do this without SQL
I am trying to print one record displayed in a form. I also need to print one record in another form at different times. I have one form working fine. It prints out the displayed record in my report just fine by clicking the Print_report button.
I copied the report and renamed it. in this form the print button is named Print_Requested. When I open this form and click the Print_Requested button, it prints out everything except for the data.
Edit: The reason I made a duplicate report is because it was doing the same thing when I tried to print the same report from different forms. One report is all I need, but I need to be able to print it from different forms.
Here is my code: -----------------------------
Private Sub Print_report_Click() On Error GoTo Err_Print_report_Click
I have 2 subforms embedded into one main form. Everything looks great on screen, and even when I hit the print preview button. But when I print the form out the 2 embedded forms will not print.
I am using multiple forms to enter some data. When I enter the data in the second form and go back to the main (first) entry form it always goes back to the first record. Also when I am at a record at the first form and go to the second form it always starts at the first record. Is there a way to make the two forms match the record I am entering. I am entering data into the same table. I needed to use two forms because I could not fit all the information on one form. Thanks
Hello- I’ve searched the forums and was not able to find the answer, so I was hoping someone would be able to help with this.
I would like to open multiple forms (cascade) in the same .mdb file when the first form is opened. There are a total of 4 forms. This is probably a very simple thing to do. I'm not much of an Access person to simple things like these throw me for a loop. Cheers to anyone who can help. -Tom
I would like to create a text box where I can input todays date, then I want to be able to select the tables I want to update with that information. So if I input todays date I can then update my Stock, Sales and Control tables with todays date. Tomorrow I would only like to update the Control and Tape tables with it as its the weekend. I been playing around with 'new date for next record' scenario but the problem is that on the weekend we would not input any data into some of the tables. Hope I've explained myself clear enough.
I wonder if it's possible to bind one form to more than one table without using 'sub-form'? I basically have one text box that I want to bind to a different table than the one the form is linked to and I don't know if I should use a subform.
