Search results

Hi, I have an access database (2007) and I have a parent table (Projects) and several child tables. For a new project record, I want to copy a child record from another project's child record (as a new project's child record) and then plan to edit the copied record. My copy operation works...

Hi folks, Does anyone know how to convert access report to PDF via VBA by clicking a button? I am building a report on the fly which will be based on: - selecting a project through a combo box - and building a query by joining several tables related to that project and then I should export...

Hello folks, I need your help. I have two forms, frmProjts1 and frmPassword. frmProjts1 has a combo box called "cbBox1" and it's ‘row source type’ property set to Value List and ‘Row Source’ property is filled with Value1";"Value2";"Value3";"Value4" What I am trying to do is when the...

Hi Folks, I want to look up a record on Form1 and then copy that record (all fileds are of memo data type on the underlying table). Now I want to close Form1 and open another form (Form2) and set all the fields of Form2 to the record I copied from Form1 and save the Form2. Do anyone have any...

Folks, I need your help on GROUP BY clause. I have been struggling to get his report in a way I wanted for some time now. Here's what I like to do: I am writing some project related data into a temp table (tblAppendForRskTblReport) by clicking a command button on a form. The data in...

Folks I need your help; just wanted to get your opinions here. I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling...

Thanks to all the folks in this forum who helped me to develop my fist access database application. Access is a great product and I really enjoy working. I need to put this db for full scale production use and I would like to brainstorm some of your experiences on the security issues I need...

Folks, Need your help. I searched the entire forum and found couple of postings on this, but none of them indicates if there is any fix for this problem. If there is no data, basically I want to show a message and close the report. I have some code to handle this under no data event like below...

Folks, Strange, I can't bring my databse window back in my screen. F11 or holding SHIFT key doesn't seem to work. Also, I have checked the check box for "display database window" on startup options. Did "Compact and Repair Databse", nothing seems to help. Any one has any idea on what's...

This must be an easy one, but I am having trouble. Can someone help me how to populate a combo box with table names (I have like 50 tables in my database) and then have user pick an item from the como box list and use that item (table name) in a select query? The combo box contains two...

Folks, can someone help me on this? I am not sure why the select query inside this procedure is not working. Here is the that routine: Public Sub temp() Dim strDocName As String Dim strTableName As String Dim strTbl As String Dim aot As Access.AccessObject Dim strSQL As...

Hi folks, Can someone help me here? I have a field with memo data type where I store like 1500 charcaters. I have a command button which when the user clicks export a query to Excel and and format it. The problem is it puts a tiny square on CR and newline as follows: For the guaranteed...

Hi all, Can some one help me with how to set a default text on a combo box whose record source is set to a query? I have a form with two combo boxes. The first combo box’s record source is set to the following query: SELECT chrCategoryID, chrCategoryName FROM tblGuarCategory; My 2nd combo...

Dear folks, I appreciate your help. I don't know how to stop this warning message. Microsoft Office Access can't follow the hyperlink to "rptMyRportName” Please verify the destination. I have a command button on a form whose hperlink subaddress property is set to a report name...

Hi folks, I need your help. Did any one get a error message like the one below: “ Run-time error ‘3061’: Too few parameters. Expected 1. “ Basically I have a form with a command button and a combo box. The combo box's row source property is set to the following sql: SELECT DISTINCTROW...

Folks, I have a form with combo box (cboProjForRptSeltn ) and two command buttons. The combo box is filled with name of the reports. The combo box has two columns, column 1 is the name of the report and column 2 is the bound column which also is the link field (primary key) to limit the...

Hi folks, I have a form with a record source property set to a query which pulls the data by joining two tables. The form also has four navigation buttons (first, previous, next, last) and a ADD record, SAVE record, EDIT record, DELETE record buttons. I also have a unbound combo box (control...