Search results for query: *

Hello, I have a bunch of excel files within a folder of which some are corrupted. The corrupted excel files don't open. I get an error message of the format: <file name here> cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or , the server the...

Hello, Please help. I have around 800 workbooks in a directory. All of them have a worksheet called 'Inspection Form'. I want to copy just this worksheet to a new workbook and save the workbook. I would like to save each new worksheet to a new workbook separately. I can do this manually but I...

Hello, I have this access database with a couple of tables and queries. For some reason, that I cant exactly pinpoint, sometimes the joins in the queries vanish and access adds 'Expr' aliases for some output fields in those queries. I think I had 'Track Name AutoCorrect Info' unchecked at...

Hello, Please advise regarding this situation. There is a back-end Oracle database from which I am planning to save data into an Access database for around 30 considerably big tables (~100,000 records each). The total size of the access database comes to 1.99 GB. I have to save this data...

Hello, Is there a way to create and save a query in an Access database using vba? Also, which is the best way to automatically run a function from access every evening around 7 PM? Form timer? Thanks a lot for your help. -cheers Arvind

Hello, I am trying to load from pictures/images from an excel file into an access table called 'inspection_temp' using the function below. I have 2 fields in that table - Pic_Num(text) and Pic (OLE Object). For each pic in the excel sheet, I am trying a add a new record in the table and copy...

Hello, I am trying to load from pictures/images from an excel file into an access table called 'inspection_temp' using the function below. I have 2 fields in that table - Pic_Num(text) and Pic (OLE Object). For each pic in the excel sheet, I am trying a add a new record in the table and copy...

Hello, I am trying to import data from a questionnaire (excel file) into access tables. The questionnaire contains controls (checkboxes, comboboxes, option buttons etc). I would like to know the best way to import all that data to Access. I can use DoCmd.transferspreadsheet function to import...

Hello, I am trying to import data from a questionnaire (excel file) into access tables. The questionnaire contains controls (checkboxes, comboboxes, option buttons etc). I would like to know the best way to import all that data to Access. I can use DoCmd.transferspreadsheet function to import...

Hello All, Please tell me if I can recover my database from this problem! My database was working fine and I regularly compact it (automatic compact on close). However, I received this 'programmed' form as an excel file which I tried to open while I had my access database open too. I got...

Hello, I'm trying to create a table/ use the corresponding table if it exists already in a 'sybase database' from my access application. There is a user DSN already created in my computer which uses a 'Sybase ASE ODBC driver'. I have a couple of linked tables in my access database which use...

Hello, Can you help me find why I'm getting a "syntax error in join operation" error when I try to execute the following query? After I press 'ok' in the error dialog box, the first occurrence of 'BndCORE_save' is highlighted. Thanks in advance. The query is as follows: SELECT *,-999 As...

Hi, I don't think there are any posts (atleast recent ones) about my problem. I have a query that accepts parameters. A subform has this query in its rowsource. In the main form (which has the subform), I set the subform control's sourceobject to the subform upon pressing a button. Now, how...

Hi, Im confused about the following query SELECT RESTATEMENT_FUNDS_LIST.PARTNERSHIP_NUMBER, LRQC_REVIEW_METRICS_QRY.FISCALYEAR, LRQC_REVIEW_METRICS_QRY.RECEIVED, RESTATEMENT_FUNDS_LIST.PARTNERSHIP_FUND_NAME, TXDBOA_TBL_BALANCE_SHEET_SUMMARY.FISCAL_YEAR FROM (RESTATEMENT_FUNDS_LIST LEFT...

Hi, I have a select query that uses 21 other queries and a table. All these 21 queries are 'LEFT JOIN'ed to this table and I am 'SELECT'ing about 2 dozen fields from this query. I also have a criteria where one of the fields should be equal to a textbox value in a form. The query is too big...

Hello, I cannot figure out why I keep getting the error "Type mismatch in expression" every time I try to execute/open the following query in design view. Here is the query SELECT LRQC_ISSUES_UNION.*, LRQC_ISSUE_STATUS.ISSUE_STATUS FROM LRQC_ISSUES_UNION INNER JOIN LRQC_ISSUE_STATUS ON...

Hi, I need to encrypt some passwords before storing in my table. I tried the RC4 encryption algorithm code. Although it works, it generates passwords with quotes (') and this creates problems when trying to retrieve the passwords using a query. I do not know much about encryption and so before...

Hi, I made a cursory search but could not find any recent posts in this topic. I am trying to set the properties of a forms, section in VBA. How do I determine whether a form has a specific section? For example, For ctr = 0 To 2 If Not IsNull(frm.Section(ctr)) Then...

Hi, I have form with a tabcontrol in it. There 2 pages in the tab control. Both of these pages seem 'to have' a textbox with the same name. As far as my understanding goes, Access doesnt allow 2 controls to have the same name. This leads me to guess that the 2 textboxes are infact just 1...

Hi, I have a form with a subform where I am populating the sub form based on the button clicked in the parent form. I have set the Scroll bars setting of the subform to 'Verticals Only'. Accordingly, everytime I open the parent form (which contains the subform) I see the vertical scrollbar in...