Search results

I’m using a function to set criteria in a an query. It reads the selected values from a combobox on a form and passes the appropriate value into the sql criteria Eg; the sql criteria is set to: like fnCountry() and the function fnCountry() is something like; If SelectedCountry...

I have a similar issue - did you get yours resolved?

I have just built a new form (Access2007) and added some Controltip Text to some of the buttons and other controls, however it takes several seconds for the text to appear - much slower than some other forms that use the same feature. Is there any way to improve the speed of these?

In my Access 2007 database I deselect the "Allow full menus" option so users can't accidentally modify the database, however we still need the Print menu options to appear for printing reports. Is it possible to enable the Print menu options using VBA (whilst leaving the "Allow full menus"...

I have seen some VBA functions that return the IP address of the PC (See sample below) but it only seems to work with Win XP. Does anyone know how to achieve this with Windows 7? ' code sample ____________________________________________________ Dim IPAddress As String Dim wsh As Object Dim...

I ahve declared custCount as an integer and id as a string that comes from the user form (id = me.CustID) and trying to count the number of matching records in the recordset (rst) using the following: custCount = DCount("[customerId]", rst, "[customerId] like '" & id & "'") I'm getting a type...

What is the best way to warn a user if a record already exists? I've looked at some examples that use an SQL SELECT statement with a recordset to compare existing records against the one the user is entering but i'm not sure which event this should be triggered by - eg; would it be the...

Is it possible to control the menu icons/commands that appear in the ribbon (Access 2007) via VBA? I have tried turning off the Full Menus (Allow full Menus option) in the 'current database' options (the users don't need all the menu options) but I still need the Print options to appear so the...

I have a form (Access 2007) that requires user to enter a date. Using the standard date field (short date format) with the date picker works fine however some users prefer to enter the date via the keyboard (some prefer the date picker). If I set an input mask (to facilitate keyboard entry) for...

i have an Access 2007 file that is 'split' so the tables are centrally stored on the server. how do i update one the linked tables stored in the back-end file with a table from another Access file? If I import the 'new' table it is not 'linked' - it is embedded wiht the Access file I am working...

I've Saved an Access 2010 File as an .accde version that opens Ok however none of the buttons (eg; delete record, go to first record, next record) that I placed on the form work at all (the standard record selectors at the bottom of the form still work). All the buttons work fine in the .accdb...

Thanks for your reply. I'm open to suggestion as to an alternative DBMS but would need to do some training as Access is the only one I've used to date and my understanding was that SQL Server licence is expensive(?) install and requires a lot of training(?) to use. What are the main advantages...

I need to deploy an Access 2007 database to a network server to allow Multi User access to the data. What are the minimum access permissions that should be assigned to the users’ directory that will allow them to open forms/reports and edit records but not directly access the tables? Should...

Thanks Mihail, That worked well! M.

I need to apply a parameter to a query based on from combo box. I have added the ALL option to the combobox which that the user would select if they want to run the query to show all records; Eg; Selecting ALL Countries would be the same as having no parameter or a wild card * ALL Countries UK...

I have a query that calculates a percentage that works fine. the sql is like so: SELECT Table1.cost, Table1.sales, Table1.location, [sales]-[cost] AS GrossProfit, [GrossProfit]/[sales] AS GrossProfitPC FROM Table1; If I try to set criteria to select records based on the calculated...

Thanks that fixed it.

I need to set some 'global' variables with default values when my Access 2007 database is loaded. Depending on the user etc these values may be modifed after Access starts but defaults need to be set. I declared the variables as 'Public' in a Module, then put a function in the same Module...

i have a question re: using dlookup in a query. i need to include a 'looked up' cost value from a table in a query so this value can be used to calculate other fields (oncosts etc) within the Query. If I use Dlookup in the query can I reference the matching record Code within the query...

I tried the square brackets around the fieldname and it worked! If that is documented somewhere I sure had missed it... Thanks for that...