Search results

i was looking for the same kind of thing i think. i stumbled acrodd this, there is a function on there that allows you to select a time and the figure is the transfered to a text box. don't know how good it is, but hope it helps. the file was too large to add so here is the link Time Picker...

I dint even know where to start with this one.... i have taken control of a database at my company, and i am now trying to create an mde file, the trouble is that for some reason i keep recieving a message saying that the current user doesn't have permission to do that. i have logged in as...

I am creating a helpdesk, and want to log the time a fault is logged, but i thought of using an automatic function, which would be fine, but the faults may come in via many different methods email etc, so the user may need to input a time in the past, i was just wondering if there is a form...

Calendar - Stop user Selecting Future date I am using the dbPopup Calendar that Milo has posted in the samples section, i was just wondering if there is a way to prevent the user from selecting a date beyond today....... i am creating a helpdesk and i use the calendar to record the date the...

right i have worked it out........there appears to be a Digital Signature on the DB... i have found a backup version which doesn't so i will use that. would still be interested in knowing how i would sort out the other one though.

Hi, i have just taken over the running of a database at my company.....big mistake. however i wanted to look at the vba code, but i i get a message saying project is unviewable.... i have a list of passwords and security for the database, but have no idea where to go to unlock to...

Thanks....Perfect

JonK, That look exactly like what i am after, but and there must always be a But.... in my example i only had 1 line called Line 1, how would i modify the sql code to display other lines also, for example line2, line 3. i would also like to be able to choose between a range of daycodes. I...

i am tring to carry out a query, that will display the number of occurances that a specific event happens, sorted by machine. i have attached and excel spreadshead to show how i am trying to get a report to end up looking like. in the table, i the columns labelled: minorstop majorstop...

I have created a form that has two text boxes on on my for that are called : WhichDaycodestartOEE WhichDaycodeendOEE i need to add to the code below, i want to ensure that the user has selected a daycode in the two boxes and a message box to appear if they are empty. but i then need to add...

i have attached a sample of my database, that produces the error

right this is every bit of code on that form... i have changed the button name to button_LME and the form name to frmLME Option Compare Database Option Explicit Private Sub Options() Select Case OptionGroupName Case 1 DoCmd.OpenReport "LME_H0", acViewPreview Case 2 DoCmd.OpenReport...

you lost me!!!! which is this: delete the erroneous one.

i have a form, that i have added a button, when i click the button i get the following message. The expression on click you entered as the event property setting produced the following error: Ambiguous name detected: LME_Click. *The expression may result in the name of a macro, the name of a...

on a plus side that kinda worked........i didn't get the error mesage this time, but on a downside, it didn't filter my data either between the 2 date ranges, i got all my data for every day. any other suggestions please!!!

right here goes...... i have a number of queries. queryLME2 - (Works Fine) Daycode, Line, Machine, TtlTime: [tblEvents]![MinorStop]+[tblEvents]![MajorStop]+[tblEvents]![Breakdowns]+[tblEvents]![CIP]+[tblEvents]![ProductChange]+[tblEvents]![Maintenance] LME Crosstab Daycode - Row Heading -...

so are you saying that the line Between [Forms]![frm_LME]![DateStart] And [Forms]![frm_LME]![Dateend] should go in the cross tab query ???

it's in the picture above!!!! isn't it??? hmmm.....now i am confused, anyway the message i get is: the microsoft jet database engine does not recognise [forms]![frm_LME]![DateStart] as a valid field name or expression. this is a query of a crosstab query, not sure if that makes a...

I am getting an error when i try to use two dates that are entered into a form Error my form name is frm_LME and my text boxes on the form are called Datestart DateEnd and the query i am trying to run is as follows: Between [Forms]![frm_LME]![DateStart] And [Forms]![frm_LME]![Dateend]...

so instead of using the following code: Select Case OptionGroupName Case 1 DoCmd.OpenReport "MyReport1", acViewPreview Case 2 DoCmd.OpenReport "MyReport2", acViewPreview ... Case Else MsgBox "No item selected." End Select how would i adapt this to suit my combo box, please my combobox is...