Search results

Thanks for the reply. Is it possible to create a form that accepts parameters for the query, then use that query to create the continuous form and the do the stuff that you suggested?

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, Some complication with the option button. The option button in the form needs to update two data items - ReviewerID and ReviewerResults. Unfortunately, Access only allows one data item to be bounded to a single control. How can I get an option button to update 2 data items at...

I just want to create a datasheet with fields that are not from a table. I am forced to bound a table or query as a source. I would like a excel-like datasheet and each cell can be modified like a textbox. Not sure if Access can do this. Sorry if this is a stupid question. I am a newbie to...

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...

Thank you very much for your reply. I am glad Access can handle the option buttons user interface entry.

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...

Thank you everyone for the answer. It is so wonderful to be surrounded by helpful gurus here.

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...

Thank you for your reply. The connection string used is below Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword; I have tried and tested a number of times that it works only on database encrypted with Access2007 encryption...

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...

Thanks for the sample files. My problem actually comes from using a user-defined function inside an Access query and getting Excel to extract data from this query. There are no UDF functions in your query. But, thank you for your help.

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...

Thank you very much!! That was the solution. The error message from Microsoft led me to a wild goose chase.

Thanks for the replies. The function which is used inside the query actually calls another query within. Is this a problem? The code is below. Public Function GetRecencyAnl(ID As String, AnnouncementDate As Date) As Integer On Error GoTo errorhandler Dim latest_year As Integer Dim...

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...