Search results

Hi Access gurus, Not sure if I should ask this question on queries or forms. I would like to implement a convenient search feature. By using queries to generate the search results, I would like to click on the row wanted and open the relevant form for that record. May I know if this can be done...

Dear Access gurus, I am trying hard to put a continuous form inside a tab control but failed. I know how to create a new form as a continuous (or multiple items) form but simply cannot put a continuous form inside a tab control. Could someone advise whether continuous form can be placed...

Dear Access experts, I am new to forms but not to Access. Recently, I am not sure if Access is flexible enough to handle forms that uses multiple option buttons for entry. Attached is a form to key in performance of job candidates in a panel of interviewers. The table data involved is...

Dear Access experts, I want to split my database into backend and frontend databases. I understand that the backend database needs to be placed in a shared location. I would like to know whether there are any restriction on the type of storage location for the backend database. Must it be on a...

Dear Access Gurus, I have a make-table query. After the query is converted into a table, the data types of the table are all "Text". What I want is to convert them to "Numbers" type. Is there some way to do this? Below is the query I used. Is this the cause of the problem? Val...

Dear Access gurus, I need to append data to existing records. I created an append query which failed due to key violations. The problem is this. New data fields were added to existing records. I need to append new data to the new data fields of the existing records. However, this may be the...

Hi Access experts, I encountered several overflow, divide-by-zero errors while running a query. It is hard to debug this query. The errors occur only on some of the records. If I use breakpoint, it will take a very long time to step through before encountering a problematic record. Did anyone...

Hi Access experts, Does anyone know the ADO connection string used for connecting to a password-protected Access 2010 database? So far, I can successfully connect to a password-protected Access 2007 database but always fail for Access 2010 database. I think this is because the encryption...

Dear Access experts, I am retrieving data from Access into Excel through ADO. It is quite slow. The data are retrieved from an Access queries. Will it be much faster to retrieve data directly from tables instead of queries? I should think table will be faster but I am not sure how much...

Hi Access experts, I would like to retrieve data from Access using Excel VBA through ADO. This was successfully done in the past until a user-defined function was added to one of the fields in the Access query. On Access, the query can run successfully. On Excel, an error "Microsoft Access...

Dear Access gurus, I am not sure if using DLookup inside a user-defined function and then using that function inside a query is forbidden. When I did that, the following error is encountered; "Cannot open a form whose underlying query contains a user-defined function that attempts to...