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...

every time you add a record it creates the service_id it's an auto number.

NO, each service id is unique i have attached a screen shot so you know what i mean.

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. :)

For the fields that have no record use the default value '0', which will then be over written by a record/action.

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...

What you say is true, but it would look sexier 00:00 instead of 5.

Yep, thats not a bad idea to work only in minutes. But what happens when some body who dosen't know the system tries to use it or tries to retrieve information. It will just have '5' or '10', i really need some kind of format/structure e.g. 00:00 any ideas on how to approach this would be good.

Nice idea wayne, but access to the database isn't always at the start of the phone call.

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 found the help file. I need '0:00' to appear and if i enter 5mins, you should see '0:05'. But at the moment all you see is '5'. That could be any value so i need that format. How do i get it?

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...

what do you mean by time serial?

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...

I just made a new button for previewing the report. So i could get a screen shot and show you what i mean. The service_id only appears for the first record, why?

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.

Ta got it

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...