Hello,
My question is, how do I make my DB accessable to users in a different location (two different states) in real-time?
I want both location to be able to add and edit data and that it is current for others to view.
We were using the DB (split) on a server in one location, but now a part...
I'm trying to build a report that has 4 details which numbers records will have to show for each detail, for example
Detail
All Passengers
Customer Payments
Supplier Payments
Additional Charges Misc Fees
When I try to build the report all of detail for the record will not show or it's...
I have split my DB, and when I go to the FE to open the swtichboard it give me an compile error: User-defined type not defined
and this where it lead me me.
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
Dim dbs As Database
Dim rst As...
A client of mine has 5 computers running Access four are running 2002 and 1 running 2003 over a SQL network. The one running 2003 is the bosses son and every since he has been going into the database with 2003it's been nothing but problems. They are now losing data once inputted--prior to this...
Im splitting my database. I want to put my lookup tables and switchboard on the FE instead of BE. My Question is do I import those lookup tables to the FE and then do I delete them from the BE. Or do I leave them in both locations
Hello
I have created a database it's on a Cisco server and ever since it has been put on this server their has been nothing but problems.
The problem is the city field which is a combo box to recall previous inputted cities.
If the city at the time is not in the combo box list the user is...
This is my first try at splitting up my database. My question is once I split it how do I relink the two? What I have done thus far I made two copies I renamed one back-end and I put the tables in that one, the other I named front-end and I left the queries-forms-report ect. in that one--now I'm...
I have created a database---I have a copy at my office and the design master is on my laptop. The problem that I am having is now since I want to sync the two.
When I go to tools down to replication and over to snyc that options is not highligted. Not the one at my office nor on my laptop. Now...
I have my Customer Form Linked to my Booking form linked to my Airline form, the problem I'm having is that---- I put a Airline Command button on my booking form but when I click on Airlines to test the form the BookingID doesnt change on the Airline form and my data stays the same. Even when I...
Hello Please Help.
I have a Travel database. When I first started entering in data my city and state fields were just input fields and then I changed them to combo lookup fields to cut back on entering duplicate city and states and to recall once entered. Now two other people that is entering...
Hello
I have a main form with a subform. On my subform I have a combo box that has pre-defined ProductNames, Cost and Sell Prices.
When I select a product from my combo box the pre-defined cost and sell amts are entered into their fields.
The problem I am having is when I manually edit the...
I'm doing a Travel Booking Database. Agents will pull certain reports of their work.
But my problem is that we do a lot of printing. Because we have to fax info to vendors.
How can we once we have printed a report in the morning and when it's time to print again in the afternoon and or evening...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.