Search results

I suggest that you post a cut down version of your database and I will have a look at it for you.

This sounds like you need a main form with the contact details and a subform with the data relating to that contact. HTH

The control source of the start and finish text boxes must be the relevant fields of the forms record source or they won't store the data.

Your start and stop fields need to have a "Short Time" format so that they show the time as hours and minutes (eg 15:30 for 3.30 pm). Create a text box that calculates the time between start and end times using =[starttime]-[endtime] as the control source of the text box. HTH

You should not be printing a copy of the form. Try creating a report that shows the same data as the form. This will then aenable you to format it how you like (with or without black borders!!) :-) HTH

Firstly I would say that your text box (suject) needs to be a combo box as well because if you do not put the correct spelling of the subject in there then the combo box will not work as you want it. I have made changes to your form (and database) and have attached it to this posting. HTH

You cannot see subform footers or headers when in datasheet view. To get round this you can put an unbound text box on your main form and populate it with the data in the calculated fields from the footer of your subform. Or of course as MStef said use the subform in Continuous View.

Tables should be just that a straighforward table of data. I made the same mistake of using lookup wizards in tables but the problem with them is that you then lose control of what is displayed which can be confusing

I look forward to seeing the fix - I have not been able to find out what is casuing the problem although I feel there is some formatting issue somewhere.

Anthony i have been able to reproduce the problem that you have. For BL:- The issue is not with the main form but with the form that pops up after you enter a value into the "From" box. This is supposed to transfer the jobref to the new form Whenever the month number has a leading zero (Jan...

As an aside to the formatting issue that BL is helping you with can I suggest that you use Select Case instead of all the if endif statements that you have. This makes the code more readable and will probably run quicker.

Setup the correct relationships between the client table and the lookup table. Use the wizard to create the Combo Box and voila it will work! HTH :-)

insert a subform which holds the result of the query.

Create a text box in the footer of the sub form to showthe totals of whatever column you are totaling. On the main form create a text box that has shows the sum of the data from the subform text box to the object on the main form.

Many thanks FoFa. I was not aware of the ID Field in SQL Server. Need to dig deeper I guess. You may be right about the upsize wizard creating the referencial integrity for me. I guess I need to do some tests before doing it in a live environment. Cheers

Hi everyone, I have several Access application(all split with Front End and Back End databases) that I want to upsize to SQL Server. All tables in these databases have an Autonumber field as the primary key. What I want to do in SQL server is use GUIDS for the PK. Is there any easy way to...

No the MDE is not an EXE file. Users still need to have MS Access installed. What an MDE does is restrict design access to forms, macros and modules.

I think Glenn wants to hide the Access title bar etc and not just those on forms in the application. There was something posted on this sometime ago if I recall but I alwasy had problems getting it to work. Glenn try a search of this forum. HTH

Hi cc109550, Neil is completely correct in his comment that you do not need to store the total. If you want a total on reports or forms etc then base those objects on a query that does the calculation for you. You cannot get the table itself to do the calculation therefore you are asking for...

You have cracked the most important aspect of development - keeping the boss happy :-) Good luck with the rest of the project