Search results

Hi all, Have a problem trying to open a form with certain dates. I have the following information:- tblReviews Learn_ID -Text Provi_ID - Text Lprog_ID - Text PlannedDate - Date/Time (Short Date Format) ReviewType - Text FrmReviewList txtLearn_ID txtProvi_ID txtLProg_ID txtPlanned txtType...

Hi all, Am a bit stuck with this one. I have a table "tblReviews" with the following fields:- Learn_ID Review_PlannedDate Review_ActualDate Reviewer I have an unbound form with the following txt boxes:- txtLearn_ID txtReviewStartDate (Format dd/mm/yyyy) txtIntervalWks txtAmountOfReviews...

Hi all, I have a form with a combo box on it and what I would like to do is when I click a command button, change the record source of the combo box from the query I currently have to a different one? Is this possible, Thanks for your time. Taff.

Hi All, Not sure if this is possible but here goes. I have a form with a time in the format "hh:nn". What I would like to do is create a query that takes the value from my form and adds a row for each 15 minute increment until it reaches a certain time i.e. 16:30. So if the time on my form...

Hi all, I have a form with the following fields:- StartTime = Format dd/mm/yyyy hh:nn:ss ExpFinishTime = Format dd/mm/yyyy hh:nn:ss Dentist = Number StartTime is bound to my table, ExpFinishTime is calculated in the forms underlying query. Before the record updates I am trying to check if...

Strange question me thinks. I have a form which is set to continous forms and requeries every 15 seconds. When the form requeries it checks the records and if certain criteria includes those records. What I am trying to do is when the form requeries, beep if anymore records appear. Possible...

Hi all, Am having some real trouble trying to work out how to do this but I'm sure it's really simple. :confused: What I am trying to do is Export the table mytable to a completely new database which would be stored in the same location as the current database. Any help is greatly...

Hi all, Have tried searching the forums but to no avail. I have a table the records imports to the database. It records the Name, Time Created, Date Created, Time Imported and Date Imported. When I import the a file to the database the Name, Time Created and Date Created are stored in...

I have a database which records vehicles passing through a weighbridge and records the date and time of weighing. What I am trying to do is create a query which shows all vehicles that have been weighed between two dates and times. What I have so far is select blah from blah WHERE...

Hi all, Really unsure how to word this so I have attached a sample of what I am trying to do. I have three tables:- tblStudents - Learn_ID Provi_ID Surname Forename tblSchemes - Learn_ID Provi_ID Lprog_ID Type_LPG ElwaOffi tblQuals - Learn_ID Provi_ID Lprog_ID Lacti_ID StartDte EEnddte...

Hi all, I have a form with Five labels on lbl1 to lbl5. What I would like to happen is have all five labels appear one at a time with a one second gap in between. Have tried on the on timer event but I seem to have all labels appear at once. Thanks Ant.

Hi all, I have a report, and when the report opens I would like to disable the menu's and only allow the user to close the report, prefferable without closing the application. Is this possible? Thanks Ant.

Has anyone come across the following? I have a table with several date fields. Next I have a query where I format the date fields so they can be exported in the correct format. I do this in my query as follows:- Date1: Format ([DATEBRTH],"ddmmyyyy") Date2: Format ([DATESTRT],"ddmmyyyy") When...

Hi all, I have a table with several records and I am trying only to show the one with the most recent date. Thanks Ant.

Hi all, I have a a form with a listbox on. When I click a command button it opens a form depending on what I have selected in my listbox. When the listbox is requeried it automatically selects the top record from my listbox. It is possible to requery the listbox but keep the record I...

Hi all, I have a database shared across a network and the problem I am having is when one of my forms is closed, if data is missing it will fill them in. If someone already has the record open is it possible to prevent opening of the form with that corresponding record? Thanks for any help...

Hi All, I have a form with several fields on which can not be null. What I am trying to do is when the user clicks a Cmdbutton to exit the form a Message box to pop up saying "Field A can not be null". When the user clicks the Cmdbutton again if the next field along is null the same thing...

Hi All, I have searched about but not with much lick unfortunately. I have a form with a command button on. When I click the command button I print the report without actually viewing it. What I would like to happen is when I click the command button it prints a copy of the report to all...

Hi all, I have a form with a listbox which displays table names with the following as the rowsource:- SELECT [msysobjects].[Name], * FROM msysobjects WHERE ((([msysobjects].[Name]) Like "Codes_LP*")); I was wondering if it is possible to have a command button that opens the table that I have...

Hi All, I have a form with a ListBox and command button on. When I click the command button it deletes the record from the ListBox with the following on the OnClick Event:- Const strSQLDelete = "DELETE * FROM [tblClaim] " Dim strCriteria As String Dim strPrompt As String...