| Thread | Last Post | Replies |
|
| Insert into? | 07 Nov 2008 16:37 GMT | - |
I have three tables made into a many to many relationship: SoftwareX, Softwarex_NameofService, NameofService SoftwareX and NameOfService holds data, SoftwareX_NameofService holds the primary keys between the two.
|
| Another docmd.Transferdatabase question | 07 Nov 2008 15:50 GMT | - |
I'm trying to transfer a table from one database to another in access 2007. When the following code is executed I recieve a 3709 "Search key can not be found" error. Here is the code
|
| Is there a better way to run a parameter query on a form? | 07 Nov 2008 13:21 GMT | - |
I have created a database for stock taking. There is a table in the database (StockCountTable) for recording stock counted during a stock taking exercise. There’s nothing I can see wrong with the table itself, it has a PK to uniquely identify an instance of each item recorded. It ...
|
| acCmdFind Problem | 06 Nov 2008 18:53 GMT | - |
I know I must be doing something really stupid, but I just can't seem to get over this hump. I have a form with 2 unbound dropdowns and a subform on it. As you move through the records, it populates the dropdowns through foreign keys in the main form.
|
| Form linked via cmd button not working. | 05 Nov 2008 21:17 GMT | - |
frmBilletEdit data comes from tblBillet with PK = [slot] (form control = [cboSlot]) frmEmployeeLink data comes from tblEmployee with FK = [slot] (frm control = [txtSlot])
|
| Error 3709 - Search key was not found in any record | 05 Nov 2008 20:38 GMT | - |
I am recieving this error when runing this code in Access 2007. DoCmd.TransferDatabase acImport, "Microsoft Access", Me.Dest, acTable, "TestingDataTbl", "TestingDataTbl" Whats weird is it works in Access 2000-2003
|
| Email and Lotus Notes | 05 Nov 2008 19:05 GMT | - |
Im using Access 2003 and Lotus Notes to send email. My Access is using a "split database". I have created the following code to send an email when the email button on the form is clicked:
|
| Open selected file | 05 Nov 2008 18:29 GMT | - |
I have a database to identify the manufacturing process instruction associated with a particular task. The process instructions are identiied as 05-03, 08-21, and things like that in which the year is the beginning of the ID. The names are assigned independent of the database, ...
|
| Access 2007 just threw my code into oblivion! | 04 Nov 2008 05:22 GMT | - |
I just wrote an event routine for refreshing a subform based on a combo box and text boxes (dynamic SQL). I saved my code fron within the VBA editor numerous times. After closing and reopening the ADP, my code changes are gone -- only the Access-generated skeleton code for the ...
|
| Changing Pivot forms | 03 Nov 2008 20:29 GMT | - |
I have been asked to upgrade an existing database and in the process of doing this I need to alter the 20 some Pivot forms to reflect different data. Currently, there are queries that culture the data into tables which in turn is displayed by forms with the spreadsheet object ...
|
| eil kredit ohne schufa kredit trotz negativer schufa kredit bonita | 01 Nov 2008 19:51 GMT | - |
eil kredit ohne schufa kredit trotz negativer schufa kredit bonitaetspruefung kredite online ohne schufa www bon kredit sofortkredite ohne schufa + +
|
| Sending mail with SendObject and Lotus Notes. | 31 Oct 2008 22:34 GMT | - |
Im using Access 2003 and Lotus Notes to send email. My Access is using a "split database". I have created the following code to send an email when the email button on the form is clicked:
|
| Capture User's Actual Name in Field | 31 Oct 2008 21:22 GMT | - |
Please forgive my double post, but I think I've been ignored b/c of the way I submitted my first post (i.e. with an afterthought reply giving me 2 posts). Here is what I still need an answer to... "jjones" wrote:
|
| Insert a bitmap image into excel via maccess code | 31 Oct 2008 04:00 GMT | - |
I can update or insert data from an access database into an excel file from access code, is it possible to insert a bitmap image using code within access into an excell spreadsheet where the bitmap image is stored in a field in a table in
|
| SaveAsOutlookContact | 30 Oct 2008 20:45 GMT | - |
Using access 2007 the Northwind DB shows a form (Employee Details) with a macro that uses the runCommand action and the argument is SaveAsOutlookContact. It works perfectly fine in that database but when I attempt to reproduce the
|