Search results

Thanks for this, looks like a much neater solution! I get a debug error on: If Me.txt_Last_Name_from_comboMe is not null then I can see that the value is populated when i hover over the code (e.g. it has "John smith" populated) but it comes up with the error: Run-time error 424. Object...

Hello, I have a form that filters another form. I want to ensure that the "txt_Last_Name_from_combo" text box is populated when the user selects the "cmd_Open_Form_Click" and if it is then open the form as usual (I already have the code for this) and if not then msgbox "You must select a user"...

Also, the type of data in the field is date (not date + time) Regards Mandy

The following code is from the Allen Browne, But I dont understand where I would need to put this..... Function SQLDate(varDate As Variant) As String 'Purpose: Return a delimited string in the date format used natively by JET SQL. 'Argument: A date/time value. 'Note...

I thought I had set all of the fields to be dates... Im going to re-check. I have used input masks of "short-date"..... Its more annoying as its not being consistant.... if it can return results as a UK date, it does, if it cant, then it looks for US dates..... I think Im going mad....! That...

Thanks guys, I'll take a look at the web-site and see if I can harass Access into doing what I would like it to (!!) Mandy

Is there a way to set the entire database to fate format: DD/MM/YYYY?

Im using the following criteria on a query: Between [Forms]![frmSwitchBoard]![Txt_FromDate] And [Forms]![frmSwitchBoard]![Txt_ToDate] and I have set all of the dates to "Short Date"

Please help! I have a query which is taking 2 date values from a form and filters between these tow dates. Txt_FromDate Txt_ToDate I think its using American dates however.... when I filter between: 01/01/2008 and 02/01/2008 it returns 01/05/2008?!?!?! :) How can I make all my dates...

ok - no worries then, Thanks, M

Hi, I have a text box on a form and I want the user to enter a date so I have an input mask. How do I get the cursor to start right at the beginning when the user selects the text box? (e.g. the format is DD/MM/YYYY and the cursor will start at the fist D and nowhere else!) Thanks, Mandy

It just gives me a data type missmatch.. Problem Looks like this: _______Asia_____Europe CP_____12_______2 MC_____10_______6 SJ______3_______10 Total___25_____18 and I want: _______Asia_____Europe___Total CP_____12_______2________14 MC_____10_______6________16...

Ah.... this seems to be beacuse the person is no longer in the "fields list" of the query I have generated based on the results from a form. how do I get the report to auto-update for the new list of salespeople available? Or ignore the fact that some of them will not be returned by the query...

I have a cross tab query populated as follows Country [as column] Sales Person [as row] I have used a query filter to filter the results based on Region, so the user can look at countries in a particular region Because of this filter I now keep getting errors when the report opens as...

I have a list box which is currently populating a query using the [forms]![frmName]![FieldName] syntax. Within the ListBox I want to select 2 entries and the query to return any values where the value is equal to any of the values selected. Per-lease.... please, please can anyone help with...

Hi All, On my main switchboard and I am designing some reports that the user can open. On the switchboard form I would like to give the user several options which will then filter the reports... So I have: Employee Indicator: [Employee] [Non-Employee] Employee Status: [Active] [Inactive] i...

Morning all, I have a report based on a cross tab. I have managed to sort of a total by column.... How do I get a total by row? E.g. My row is sales person. My Column is Sales Country. I can get a total per country, but how do I get a total per sales person? Many many thanks, I have tried...

Phew..... Thanks, :)

Hi all, I managed to disable the scroll button on the mouse using VBA and stop the user selecting the toggle buttons at the bottom of a form by setting "Navigation Buttons" to No. However, I just noticed that I can tab through all of the fields in the current form record and when I reach the...

works a treat, Many thanks, Mandy