Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: logopolis
  • Order by date
  1. logopolis

    Importing Data Rejected Records

    No, I was expecting one but it didn't appear
  2. logopolis

    Importing Data Rejected Records

    I am importing data into a table and I have set up specific validation on some of the fields. I am expecting some records to be rejected as they have fields which do not fit the validation. It is rejecting these records but does not tell me which records have been rejected. Is there any way to...
  3. logopolis

    Creating a list of dates from a date range

    Hi sorry I was a little vague. There is a table of term dates for a school, Start, end and half term start and end. The database enters in two sorts of booking, one would be for a one off booking eg. an appointment. and then there would be a repeadted booking eg. period 3 on Tuesday. It is for...
  4. logopolis

    Creating a list of dates from a date range

    Is it possible to create a list of dates in a query from a start and end date in a table. eg I have a start date of 1st Jan 2006 and and end date of 30th Jan 2006 and it lists all the dates in between as a new record. John
  5. logopolis

    Validation of Date with Reference to other fields

    I have a date field which I want to validate against four other date field in another table. I have combined the information in a query and sourced the information for the Form from that query. The date entered must be between Date1 and Date2 or Date3 and Date4. If it is not I need a message box...
  6. logopolis

    Amalgamating two time fields

    I have been so stupid, that is so obvious. Thank you so much for that.
  7. logopolis

    Amalgamating two time fields

    I have two time fields time1 and time2. Where time2 has no entries I want to enter time1's data. I have created a NZ function to insert a 0 when there is nothing in time2 and have created the following expression in a blank field. IIf ( [time2] =0, [time1] , [time2] ). When I run the query it...
  8. logopolis

    Updating a field in a form

    I have a field in a form which shows a figure from a query which is from a Count calculation. When I change information which realtes to this Count the figure only changes in the form when I close the form and reopen it. It does not change when I click on a refresh command button. Ideally it...
  9. logopolis

    Command Button Error

    When I put a command button on a certain form I get the following error message stateing "The expression On Click you entered as the event property setting produced the following error: A problem occured while Microsoft Office Access was communicating with the OLE server ot ActiveX control...
  10. logopolis

    populating a sub form

    Is it possible to populate a subform when certain information is put into a form. E.G. If you wished to record results for different students who are in different classes. Each student would be recorded in a table with his/her class in the same table. When you come to the form to record results...
  11. logopolis

    Limiting the size of a web page

    I am designing a website using Adobe GoLive 5. I have set up some of my hyperlinks on the pages to open in a new window while leaving the original window open. I want to be able to specify what size this window opens and also to remove all the shortcut and address information at the top of these...
  12. logopolis

    Cursor postion after refresh

    Hi AceMan1 Thanks for the help. I have put the line DoCmd.GoToRecord acDataForm, "Daycare Choice subform", acGoTo, acLast But whe i run it it tells me that the Subfrom isnt open. Any ideas John
  13. logopolis

    Cursor postion after refresh

    I am using the following code on a subform (which is in the form of a list) Private Sub Course_ID_Change() On Error GoTo Err_Course_ID_Change Forms![Information Input].Refresh Exit_Course_ID_Change: Exit Sub Err_Course_ID_Change: MsgBox Err.Description Resume...
  14. logopolis

    Refresh from subform

    Is it possible to refresh a form from an action in the subform, how do i change the code to refer to the form? Current code is: Private Sub Form_AfterUpdate() On Error GoTo Err_Form_AfterUpdate DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Course_ID_Exit: Exit Sub...
  15. logopolis

    How do I use Dsum?

    that did it, brilliant. Thank you very much. John
  16. logopolis

    How do I use Dsum?

    yea i have tried that, but when it enters the field from the query it put it in like this [TotalCost5]![SumOfTotal] so the whole code becomes like this: =DSum([TotalCost5]![SumOfTotal],[TotalCost5],[TotalCost5]![AddressID]=[AddressID]) Leaving of the NZ function for the minute.
  17. logopolis

    How do I use Dsum?

    Yes there is a field called addressID in the same form as the txt box.
  18. logopolis

    How do I use Dsum?

    i dont think its a requery problem. I have a macro set up to requery conected to a command button, so have run that. The field just has #Name? in it
  19. logopolis

    How do I use Dsum?

    I have entered it into the control source of an unatached text box on the form. The addressID is numeric
  20. logopolis

    How do I use Dsum?

    I have entered the formula as follows =Nz(DSum("[SumOfTotal]","[TotalCost5]","[AddressID]=" & [Me]![AddressID]),0) Where SumOfTotal is the field in the query TotalCost5 is the name of the Query and AddressID is the id field in both query and form Its does not seem to run, am I doing something...

Part and Inventory Search

Back
Top