Search results

Thanks RG. <CTL><BREAK> worked nicely. I paniced a little there. Tried every other <CTL> combo but that. Regards Brett

Here is what I use. Albeit right or wrong, it works for me. Using a Master Module, in your global declarations put... 'NOTE: The following "Declare" statement is case sensitive. Declare Sub SetWindowPos Lib "User32" (ByVal hWnd&, ByVal hWndInsertAfter&, ByVal X&, ByVal Y&, ByVal cX&, ByVal...

HELP!!!!! I have managed to place a project in a perpetual loop... On got focus, a control checks for data in another control, doesn't find it, opens a msgbox and then checks the control again so it constantly loops. All I can now do is click the msgbox and watch it pop up again. I cannot...

Sydney - Rouse Hill to be exact. Nice to "meet you". Brett

Thanks namliam, I do appreciate your input and find it stimulating, not critical. The issue with this case is that I am needing to get the staff to fill in the forms online and stop using the horrible paper forms they currently use (and abuse with you don't want to know what). They also only...

namliam, How does "ID/Period/Day/Amount" give me Login/Logout x 5 times (possible) in one day with one table but showing a full week on the page (70 controls)? I am already using one table with data stored as (week value) to give me the start date and (log10) thru to (log 79) for the weeks...

Whoooohhhh.... Lots of replies with this one. Thanks guys. namliam... 200 controls??? Actually there are a max of 70 main controls on the sheet (plus some other non important ones). It is a timesheet with the ability to log time b4 morning tea, b4 lunch, b4 arvo tea, before knockoff, and for...

I have a need to modify a control on a form by using a string formula. I was trying to use Eval() but have now discovered that this doesn't do what I want. Here is my code... Public Sub AllowComboEdit() frmName = Screen.ActiveForm.Name PublicName1 = Screen.ActiveControl.Name...

Thanks namlian. You were quick. Got the answer to me before I was able to finish re-editing my post. This was originally not the same question so didn't see the need to continue with the original. Here is my final solution to getting a ComboBox to display the current time rounded to 15...

Thanks namliam, No particular reason for doing it this way - just thought it was a little cleaner and more versatile. Thanks for the tip about the brackets. It works great now. Cleaned up a little too. Public Sub FillComboTime(ctlCombo As ComboBox) For i = 0 To 95...

I am creating a simple Timesheet that will require users to select their start and finish times etc from a ComboBox which will give them selection options in 15 minute intervals. I want to fill the ComboBox selections automatically with a common Function call. My problem is that I am having...

Hi, I have just finished developing an application in Access 2003. I want to test how the runtime actually looks and feels - not in the full version emulator but in the actual runtime. I installed the runtime version on my computer this morning but have no idea where it is or how to get to...

Thanks for the input guys. The spaces were not actually missing from my statement however as I was using only one line I thought it would make it easier to read if I quickly edited it for display. Kinda forgot that you would probably cut & paste it to check the syntax. Whoops. The answer...

I have an SQL update query that is performing badly and I was wondering if anyone can give me a pointer please? Is there any issues with using a public variable within an SQL statement? The following code works perfectly if I remove the reference to PublicVar. Setting a break point I can see...

RuralGuy, Your blood is worth bottling. That worked a treat. One last question though... When stDocRange ends up equalling "OutDate Between #1/06/2008# And #30/06/2008#" and this works however typing DoCmd.OpenReport stDocName, acPreview, , "OutDate Between #1/06/2008# And...

Thanks RuralGuy, Still striking out. Even being very specific and typing... DoCmd.OpenReport stDocName, acPreview, , "OutDate Between #1/06/2008# And #30/06/2008#" ...yeilds a report with EVERY sale - not just the range selected. DoCmd.OpenReport stDocName, acPreview, , "OutDate...

Not sure if this is the correct forum but it is form based so... I have a form with two boxes and a button (using KISS just to see what could be wrong). RRange1 is short date format unbound text box RRange2 is short date format unbound text box Outdate is a field name with lots of records...

It appears to me that one cannot create a report that is say 12cm wide (designed to be initially viewed on screen) and then optionally printed out centered on an A4 page. I have tried setting the initial report page width to 12cm but the display always sets itself to the paper size selected...

I appreciate your reply namlian but you really don't tell me much. Firstly I need to read Time(). Convert it to the nearest 15 minute interval (10:41 = 10:45). Then display a continous range of times before and after the current converted time. Using "some code" to generate this is somewhat...

how about something like... if left(Format(Field_Name, "Long Date"),1) <>"F" then... Brett