Search results

I created my database which works great. But when try to save it as a HTML document i get the following error "cannot find the database or some database objects that this page refers to. Update the connection information of the page, or fix the references to the missing database objects." Is...

I have created a tab control and pasted all my controls, so you can click to the second page and it's empty which is fine. But i have two link combo boxes as part of my controls and the second combo box stops working as soon as i put on the tab. Is this a bug or do i have to enable something...

I have designed a report with all the right fields and look. Their is a section of the report which displays the a service record/s for that Report. Linked to each service record is a Record Id, but the ID(service_Id) is only appearing for the last record. I want it to appear for every record...

I have designed a report with all the relevant fields, but how do i filter the report to print all records for just one customer 'XYXZ'. This will proberly be pretty simple but i don't know how to do it. So any help would be great. :)

This is proberly simple.How do i get a text field if empty to show the current date/time, and once i enter data in other fields to record/save it. It also needs to be editable for back dating. eg. on subform txtdate: TODAYS DD/MM/YY, time(if null) actions: blah blah blah blah It's tricky...

I need to setup a text field for the duration of a phone call. I want to enter '5' and have the text field display 00:05 and '10' 00:10 etc.... at the moment it just displays '5' or '10' what ever you entered. But these could be 5 days or 10 hours, so i need a format. I have tried playing...

I had the report setup exactly how i wantted it with the heading for a branch and the details for each record below. But the dates for each record were in a random order. So i used the 'sorting and order' button in design mode to display the dates in ascedning order. But now the report has gone...

I am creating a text field to record the amount of time spent on the phone to customers. But all the time formats that access lets you choose change the number into a clock format. e.g if i enter 00:10 for 10 mins call duration, acess changes it to 12:10am. I have also tried using a long...

My report button now works and prints the right record. But a part of the report contains a another ID number. Used to uniqely identify every service record. But the number(Service_Id) only appears on the first record. So it's there and prints but once and only once.

I have created a report using the wizard called service report. I have added a button to my form(MainForm). I want it to print the particular record that i am currently looking at. But when you click the button it prints every record. I have never done this before so i have no idea how to fix...

Somebody else wrote the attached query, it filters my form by the first combo box(branch_name). I want it to filter the form by both combo boxes cbobranch_name and cbobranch_city. It would be good if somebody could help. Cause this is the last thing to do on my companys database, then it's...

I have finally managed to get my combo boxes working correctly. They cascade correctly and show the right information. But now my text fields and sub form don't update from their selections. cboBranch_Name cboBranch_City txtBranch_Contact txtBranch_Phone txtBranch_Address Their is also a...

I am attempting to populate text box Contact_Name. The contact name should be selected from the choices made in two combo boxes, cboBranch_Name and cboBranch_City.There are many different cities in a branch_name, but each city has one branch contact. All these fields are in one table, Branch. I...

I have entered the following in the control source of a text box. But it dosen't work and every time i open the text box again in design mode, the script is missing. I am trying to display a contact name(in a text box) from a selection made in two combo boxes, cboBranch_City, cboBranch_Name...

I have written a query that works, it's output is a contact name. I am trying to have two combo boxes define the contact name. combo 1 branch_name combo 2 branch_city text box branch_contact The user makes a selection in each combo box so the contact name will then appear in the text field...

I am attempting to have a contact name displayed in text box Branch_Contact. But the result depends on the selection made in the two previous combo boxes cboBranch_Name and cboBranch_City. I have made a Query(branch Query) that displays the contact name when run by it self, but when inserted in...

I have managed to sync my combo boxes to filter and update with the correct information(only took me two weeks, lol). But now i am trying to update the text fields below them with the filtered selection from the combo boxes. combo box 1= Branch_Name combo box 2= Branch_City Text field 1 =...

I have a form that has two combo boxes, some text fields, and a subform. I have managed to get the combo boxes to cascade and display the correct information. But their are two problems. 1. The combo boxes only filter the first choice made in combo box one. If you try to update the selections...

I have two check boxes(cboBranch_name & cboBranch_City) cboBranch_name displays the correct information. cboBranch_City is supposed to filter it's list depending on what selection you make in cboBranch_Name. But instead it opens a dialog box asking for input. I have entered the following code in...

I have two problems: 1. I have a Form with a subform thats needs to be updated from the Combo boxes on the Main form. When i select the relevant data(Branch_Name, Branch_City) in the combo boxes nothing happens on the sub form(Service Record). The Combo boxes are called cboBranch_Name and...