Search results

Am I thick and if so, do I need to be publicly flogged? I have some code which completely hides the Access window. All the user sees is the main form. I understand that because this form is popup, I will have to toggle the visible property of the form and report. This is where I am stuck. My...

Sweet :) Cheers Rich

Thanks for the reply. ClosedDate is not visible on the form so, as the user does not see it, no input is necessary. When ClosedDate is visible, input is required. I could set the field value to 'no' but that would defeat the purpose. The idea is, input would only be required if ClosedDate is...

Pas de problemè Oh, you could also Export your deletes table within the current database (to another table) and not necessarily to an external database. Bonne chance :)

Transfer database Hi Troy (hehe) You could create a macro to Transfer your deletes table (export) to another database. This is what I do: Create a new macro Select Transfer Database from the dropdown list. In the Transfer type field, select Export. Specify your source and destination. Make...

If Visible... Thanks for the reply. I could but I actually want the field ClosedDate to have required input... but only if it is visible on the form. If it's not visible, the user would not see it and therefore input should not be required.

I have a text box called 'ClosedDate' If the CheckBox 'Closed' is checked on the form, ClosedDate appears. If Me.Closed = 0 Then Me.ClosedDate.Visible = False Else Me.ClosedDate.Visible = True End If This works great except input is required in ClosedDate so even if it is not visible, input is...

I have a text box called 'ClosedDate' If the CheckBox 'Closed' is checked on the form, ClosedDate appears. If Me.Closed = 0 Then Me.ClosedDate.Visible = False Else Me.ClosedDate.Visible = True End If This works great except input is required in ClosedDate so even if it is not visible, input is...

Hi Ray_Charles Here's what I do. On the 'On Got Focus' property of the combobox, use this code: your_combobox_field_name.Dropdown Now when you tab to the combobox, it will drop down automatically and you can then scroll via the keyboard arrows, find your selection and a normal keyboard...

Curious... Hi Cable What are you actually trying to save? The data? - it's not necessary. Does the user have the ability to edit the form in design view? Is this what you want to save?

it works! Thanks Audrey, you're a legend - works a treat :)

I have a form with a text box (ClosedDate) and a checkbox (Closed). ClosedDate is defined in my table as Date/Time and Closed as Yes/No. What I want is, when a user clicks the checkbox(Closed), the textbox(ClosedDate) appears. I have played with .Visible and sort of got it to work. Problem is...

Date format prob fixed. Thanks Rich. You are indeed a legend :) My records are no longer lost. On the topic of regional settings, these were already changed to 'dd/mm/yyyy'. The problem is with SQL in VB. Straight from the MS Access help: You must use English (United States) date formats in...

Checked the numerous posts about this but still having probs... stSQL = stSQL & " WHERE tblChanges.ImplementationDate Between #" & Format([txtFrom], "dd/mm/yyyy") & "# And #" & Format([txtTo], "dd/mm/yyyy") & "#;" I want the user to be able to enter the date in format dd/mm/yyyy to retrieve...

What's in a ' " ' ? Sorted! Thanks all for your help :)

Thanks Colin but there is no query design grid. The query is generated from the underlying VB/SQL and then deleted - the results are output to a report. If I use Cstr[bla bla bla] in my VB/SQL, the text is treated as a field (which obviously cannot be found). I know it's simply syntax but...

How do I put spaces in the text in my Parameter box? At the moment I have 'spaced' out the words "Enter your Group name" with Underscores. It looks terrible :( but it works. If I put hard spaces, I get a syntax error. Code: stSQL = stSQL & " WHERE (((Year([ImplementationDate]))= " &...

Re: WHERE and AND After crying for my Mum and exhausting my supply of ciggies, something popped in that thing of mine I seldom call a brain. Solution: stSQL = stSQL & " WHERE ((Year([ImplementationDate]))= " & CInt(txtSelectDate) & ") And ((tblChanges.Group) = " & CStr(("'ADEL'") & ")") Now...

WHERE and AND Hi Thanks all for the help. Still having 'minor' probs. I am at the stage where I input my date in my form (say 2002) but instead of the query running and pulling in all records for 2002 with a GROUP of ADEL, I get a box asking me for the word ADEL. I enter the word ADEL in the...

Where am I going wrong? stSQL = stSQL & " WHERE (Year([ImplementationDate]))= " & CInt(txtSelectDate) And tblChanges.Group = ADEL This is the bit that's killing me And tblChanges.Group = ADEL Without it the query works a treat except it pulls in all records based on the date range. What I...