| Thread | Last Post | Replies |
|
| ODBC Connection Failed | 05 Jun 2008 20:05 GMT | 1 |
How do I set up an ODBC connection? I see the administration tools in the control panel, but not sure how to set this up so that it connects to the database that is failing. Don't know what happend, because it use to work, but now this morning I'm
|
| Very Small Form | 05 Jun 2008 20:04 GMT | 5 |
I have a form that when it opens is very, very small. I've played with every property but can't fix it. Does any one know which property I have mis-set?? thank You
|
| Unbound Textbox with Parameter Query | 05 Jun 2008 17:56 GMT | 3 |
I have an unbound textbox "txtTicker" in a form where I would like to enter a ticker ie. "IBM" to pull a rating "SchwabGrade" from a table "Model Data" into another textbox "txtSER". The table is in L:"\Member\EventData.mdb" I'm using this code below to try and do it: I ...
|
| Transfering Data | 05 Jun 2008 16:59 GMT | 4 |
I've been given the task of transfering data from an access db to sql server 2000. The previous access db was not structured very well so we reconstructed the tables in sql server 2000 to add better table structure and more functionality. What I want to be able to do is
|
| Comparing data between 2 tables | 05 Jun 2008 16:35 GMT | 1 |
Dear Friends , I have 2 querries viz qrybilllog & QryBudget qrybilllog is summury of state wise billing recorded for a period -with fields billed_date, bill_Amount, Branch_Name
|
| Form on open shows 2 records exist when recordset not open | 05 Jun 2008 15:55 GMT | 3 |
How do I clear the form when opening so that it just shows the blank form and 1 of 1 records? I use ADO to query and populate the form after clicking a button so I don't know why the record bar is showing that 2 records exist (which are both empty) when nothing has been done yet ...
|
| From Dialog, Find record, If No Match then New Record | 05 Jun 2008 15:46 GMT | 16 |
I have to make a entry form for people that are not tech savy. The route I am taking is to use a dialog with selectable parameters on it. When the user clicks the button, I want the form to search for the criteria from a table. If the criteria matches, open entry form
|
| I need help with locking selective cells in excel | 05 Jun 2008 15:26 GMT | 3 |
I am exporting a table from Access to Excel for some one who is going to make comments in specific columns then I import the excel file back to access with the comments. The system works OK importing and Exporting however, I am trying to lock columns A:M and unlock N:R for the ...
|
| Find subform control name | 05 Jun 2008 15:19 GMT | 1 |
I created a form with several tabs which contains a subform. I'm trying to find the name of the subform control on each tab, how does one go about retriving this information? I changed the name of the subforms to corrispond to the form it references (ie. Form Name: FrmCustInfo, ...
|
| Question regarding Status Bar Text | 05 Jun 2008 15:01 GMT | 3 |
Group: I have used the following statement to delete the words "Form View" from appearing in the Status Bar at the bottom of the window when my Splash Screen form opens.
|
| One to many OR one to one with same data | 05 Jun 2008 14:50 GMT | 11 |
Access 2003 Windows XP, SP3 This is still in the design phase. I'm trying to determine the best table structure to end up with a form where I can input all info for one contact.
|
| Dlookup in ControlSource | 05 Jun 2008 14:43 GMT | 2 |
I need to change the controlsource of a textbox depending on the value of a combo box. On the AfterUpdate event of the combobox I have the following statements: Select Case cboboxvalue
|
| Query a Form's Underlying RecordSource | 05 Jun 2008 14:08 GMT | 7 |
I have exhausted my search for a solution...I would appreciate your help. I have a Main Menu from where I launch a small pop-up form that lets the user select a "department" name from a combo-box. After he does this, a standard form is displayed that shows specific information ...
|
| search query construction | 05 Jun 2008 12:38 GMT | 3 |
Although I’ve been using access for a number of years and have built a number of databases I have not as yet been able to interrogate a query from a form. I would like to be able to do this. Essentially I want to create a form which has an empty ‘parameter query’
|
| How to run VBA code on all rows of a table | 05 Jun 2008 12:14 GMT | 9 |
I have VBA code that "scores" each row in a table when I push a button. It executes three sub-routines. call subA call subB
|