Search results

Is there any kind of input mask I could create to make sure that the user always enter the date in the format - dd/mm/yyyy hh:mm:ss

I have got a form which has on it 2 text boxes formatted to Short Date dd/mm/yyyy (Start and End dates). Is there anyway in which I can format them so that I can enter the date as follows: dd/mm/yyyy hh:mm:ss? Regards Carly

I am using Microsoft Access Project and I have got the following stored procedure which creates a table:ALTER PROCEDURE dbo.[Qry D1 GroupedFail&Success] (@EnterDate1 datetime, @EnterDate2 datetime) AS SELECT CONVERT(char(10), wcs_entry_date_time, 103) AS Date, RTRIM(wcs_zone) AS Zone...

Yes I think so.

Does anyone know what the maximum rows & columns are for a crosstab query as I cannot find them anywhere? When I create one that is too big, it just gives the message of how many columns I have rather then how many I'm allowed. Any help would be greatly recieved. Regards Carly

Thanks that was a great help!

I have got a formula in a Query as follows: Suggested Qty: [StockQty]/[Numerator] How do I round this down to the nearest 1? (i.e 7.2 = 7 or 9.9 = 9) Any help would be greatly received. Regards Carly

I would like to force a field to be 2 decimal places in the SQL view of a query as I am creating a UNION. If is there anyway of doing this? I have tried CONVERT() & FORMAT() but I can't seem to get this to work. Any help would be greatfully received. Kind Regards Carly

I have a crosstab query which contains 1 lrow & 4 columns. The column headings are vendor numbers & the value is Sales. I would like to sort the crosstab by the value rather that the column headings so that the greater value is at the start but it is automatically sorting the columns into...

Thanks for that...I knew I'd done this somehow before but couldn't remember how

I have got a query which runs to create a table containing Vendor Number & 12 Months Sales for the Top 4 Vendors. What I then need to do is create another query which does exactly the same as the above but for all other vendors apart from the 4 in the above table. The vendors will always be...

Thanks for your help, this worked fine! Regards Carly

:confused: I am currently using the following Select Case Statement Dim Id As String Id = DLookup("signedoff", "Check") Select Case Id Case "X" Me.RunMacro.SetFocus Case Is <> "X" MsgBox ("This vendor has not been signed off for the selected period.") Me.Period.SetFocus...

That's work brilliantly Thanks for all your help Regards Carly

Mile-O-Phile, I edited your code so that it would work with my data as follows: Private Sub MyButton_Click() On Error GoTo Err_MyButton_Click If Me.ProductGroup.ItemsSelected.Count = 0 Then Exit Sub Set db = CurrentDb On Error Resume Next db.QueryDefs.Delete...

Sounds good but I've never heard of that before. Could you point me in the right direction? Thanks Carly

I currently have a textbox on a form which is linked to a query by [Forms]![FrontPage]![ProductGroup]. What I want to do is enter multiple entries into this textbox so that the query will run for more than one product group? i.e. Like typing in 33 or 43 or 45 etc into the criteria row in a...

Thanks - That's worked a treat Regards Carly

I have used the DateAdd function before but I'm not 100% sure how it works. How would I write the formula to say 1st March minus 1 day?

I currently enter a date into a text box in a form in the following format: 200401 = Jan2004 From this I would like to work out a future date which will always be the end of February or the end of August depending on which month I am reporting on. I have done this for August by using the...