OK, the "security vs. functionality" war has another casualty here. I've made a database I'm perfectly happy with on my development workstation. On that workstation, I've chosen "Tools/Macro/S...
MS Access 2003 - I have just split my database. I know want to make both halves .MDE files. However, first I need to know the location within the databases which tells each where the other i...
In a Continuous Subform I have a button named CmdOpen_EQFL
For every record in the subform how do I get a record specific bookmark or reference to this command button so I can control wheth...
I have a form bound to a table, tblInterviews. On the form is an un-bound combox box which allows the user to select from records in a table named tblPositions. When the user selects one of ...
I have a database that I have created and now I need to add 40 fields to one of the tables. I have a list of the fields in Excel. How can I add these to the table without retyping all of the...
Sorry if this question vague, but I'm dealing with vague requirements from the client. I have a Query by Form interface that has been working well for the client. The form composes of dropdown...
We have an available connection between SQLSERVER 2005 and a converted ACCESS database from 97 into
ACCESS 2003.
We exeperience a problem for what concerns the linking if ACCESS 97 is not co...
I need some robust code to enable me to delete all linked tables in my MDB, but leave all the non-linked tables as they are.
This should be easy...High points for a fast answer!
This is a continuation of a problem I had before. When a bounded form is a subform in an unbounded form and the allow edits property of the subform is set to false: If you try to delete a reco...
I recently inherited a MS Access application that I need to extract the data from. I know the user password for the original owner but when I sign in, a box pops up that says " Enter password...
When I load my .mdb app, the database window (the window that displays a menu of objects and modules like tables, reports, etc.) doesn't appear. I have never had this happen before...how do I ...
I click on the Table , delete it to break the link...then I go to File, Get External data and import. I navigate to the other database that contains the linked table. I select it and click O...
Hi all,
I'm using some code to re-link in some SQL Server tables using an ODBC connection, without a DSN, into MS Access 2003 SP2. It works fine, but the tables are re-linking as Read Only. ...
Say I've got two different "backends". They have the same structure but different data. Can I build another "front end" that can pull data from both backends? And if I update data on that ...
I have an Access from that a user can enter daily report comments into a text box sourced to a field called "comments". Most users like to type short comments with a carraige return and they d...
I have form set up that runs off 1 table. The table has many records and fields. I have 5 buttons set up for filtering the form. I have already had 2 attempts at this. The first was to use...
I have a connection to an SQL database and want to grab the value of a field called state.
The State field appears in a subform that is populated (filtered) when a combo box is changed.
Th...
Is it possible either in Excel or in Access to take data that is over 240 characters, cut it off and move the remaining character to another field and then again if it is over 240 characters t...
Folks,
I've not done a form/sub-form and after feeble attempts I need help. My table tblDailyProduction has three fields I need to key off of: ProductionDate, LineCode, Shift.
Let's start wi...
Hello,
I have 2 subforms in which they are table driven. reason why is because these 2 subforms control a check box, [Complete] ,that modifies the table 0 or -1. i have create 2 command bu...
I have an Access database that when loaded needs to ensure that the application and then the form are maximised. I thought a good idea might be to put the following code into the Main Menus l...
hi,
I have the following code under Report_Open of my report:
If IsNull([Forms]![frmNMain]![cboSortBy]) Then
[Forms]![frmNMain]![cboSortBy] = "RNo"
Else
Me.OrderB...
I want to create a validation rule that will only allow entry in a field when a previous field is marked yes. I have a several yes/no fields in a form and one of them is other. If the user ...
I am quite good at cleaning down variables such as recordsets etc. But I wanted to know if there was a function that would cleanly wipe any variables - just to double check things (for exampl...
I am working on code that will search queries, forms, and reports for certain a given key word (it could be a table name, field name, etc)
I have the code below which works perfectly for th...
