Search results

  1. Fear Naught

    Display Form as Datasheet with many-record queries?

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

    Display Form as Datasheet with many-record queries?

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

    Time and date problems

    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.
  4. Fear Naught

    Time and date problems

    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
  5. Fear Naught

    Formating a subform for printing

    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
  6. Fear Naught

    Combo box

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

    Total on a subform

    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.
  8. Fear Naught

    Help with Table build

    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
  9. Fear Naught

    refernece number missing digit during form transfer

    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.
  10. Fear Naught

    refernece number missing digit during form transfer

    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...
  11. Fear Naught

    refernece number missing digit during form transfer

    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.
  12. Fear Naught

    Combo boxes - values and titles

    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 :-)
  13. Fear Naught

    Help with a form and cross tab query

    insert a subform which holds the result of the query.
  14. Fear Naught

    totals

    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.
  15. Fear Naught

    Upsizing from Access Backend to SQL Server

    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
  16. Fear Naught

    Upsizing from Access Backend to SQL Server

    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...
  17. Fear Naught

    Password protect VBA code

    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.
  18. Fear Naught

    Access In Full Screen View (no title bar or taskbar visible)???

    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
  19. Fear Naught

    Access Form Calculations

    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...
  20. Fear Naught

    Use popup form to select a record on the main form

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