Search results

I have a multilingual database. currently I set a public code when a user logs on setting the language to be used on form Labels and report Labels. I use the on load event in forms and on Current event for reports to set the labels caption eg if gbllanguage = "English" them me.label1.caption =...

thanks I will try that, have started to play around with dcount function as that was an easy option. But still need to get the syntax right for future reference

OK failed again when moving to my actual problem query replaced the firlds now to actualy look up the query that I need to chek if it returns records or not. now get the message: 'too few parameters: expected 2' - debug highlights the Set rst = CurrentDb.OpenRecordset(strSql) line where does...

thanks got it

If I remove the comma I get a syntax error (missing operator) in query expression. Get a bit frustrated with it now...it seems so simple

I tried a test with a simple module/query but keep getting the following error? "the select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" Where do I go wrong here? Private Sub Command0_Click() Dim rst As DAO.Recordset...

I tried a test with a simple module/query but keep getting the following error? "the select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" Where do I go wrong here? Private Sub Command0_Click() Dim rst As DAO.Recordset...

:confused: When I run this moduel I get a syntax error in string in query expression, 'queryincorrectprices.cat='false &;' I also get an error on the group by expression. - expected: line number or label or end of statement the end result is to display the query result on a message box, Hwr I...

The SQL code would be as follows but what code should I add to decide if there is no result? SELECT qrystartcalculateyearlyschedule1.DispRef, qrystartcalculateyearlyschedule1.SellPrice, qrystartcalculateyearlyschedule1.[official pricelist] AS Cat FROM qrystartcalculateyearlyschedule1 GROUP BY...

I am trying to educate myself programming access 2003 using the ADO, hwr when using syntax such as ADODB.Recordset I get a user type not defined error. I suppose I am missing some references in my librabry but not sure which reference to add.. could somebody point me in the right direction here?

I use a database that calculates costs based a range of parts on list prices. Some parts that are being used are not officially priced and have a guide price. these are marked by a true false in the table. The calculation uses various queries. When executing the calculation I want to warn the...

Not sure if someone has come accross this probelm but I am unable to link/import tables from excel or text files. I am able to import tables from other databases but as soon as I want to import an excel file it seems that the import wizard simply doesn't exist. re-installed office several times...

What code should I use to set a specific field format using the on load event. For example my database is used by different countries. in their setup the can choose to use Euro or GBP as Currency. When they log on I set this as a global constant (GbCurrency) Depending on their setting when they...

What code should I use to set a specific field format using the on load event. For example my database is used by different countries. in their setup the can choose to use Euro or GBP as Currency. When they log on I set this as a global constant (GbCurrency) Depending on their setting when they...

What code should I use to set a specific field format using the on load event. For example my database is used by different countries. in their setup the can choose to use Euro or GBP as Currency. When they log on I set this as a global constant (GbCurrency) Depending on their setting when they...

in your report add an unbound text box. Call that for give it a useful name eg Customerdetails Select your report / section header. In the properties select the on format event. select code builder than write the code as you would like it to appear: me.customerdetails = ...

in your report add an unbound text box. Call that for give it a useful name eg Customerdetails Select your report / section header. In the properties select the on format event. select code builder than write the code as you would like it to appear: me.customerdetails = ...

in your report add an unbound text box. Call that for give it a useful name eg Customerdetails Select your report / section header. In the properties select the on format event. select code builder than write the code as you would like it to appear: me.customerdetails = ...

Used your second suggestion works like a treat thanks

It works now many thanks