| Thread | Last Post | Replies |
|
| Adding working days | 08 May 2008 14:18 GMT | 5 |
I'm creating codes for a field (in the form) to return 10 working days from the initial date. Initial date is given and I want to get the date, 10 working days from the initial date.
|
| Using a physical object in a from thru a module? | 08 May 2008 14:09 GMT | 1 |
I am trying to call a function in a module from a form. It will fill some data in a real ListBox object placed in a from. Using this code: In Module: Public FP As Form_Process ' Name of the Form
|
| Hyperlinks | 08 May 2008 11:12 GMT | 1 |
In my database I have a contacts table which includes their email address as a hyperlink field so that I can click on this via a form and open an email message form in Outlook Express. But I also want to group these for sending mail to all of them at the same
|
| Import csv to different tables | 08 May 2008 08:19 GMT | 14 |
I have a csv file that need to import to Access database. The csv carries two types of data: PO header and PO lines. They are in different format and length, which should be imported into two different tables: tbl_header and tbl_line.
|
| What's recordset2.parentrecordset propery? | 08 May 2008 05:18 GMT | 1 |
I'm wondering what's a good way to relate 2 recordsets (one to many). I have a form for user to narrow down which records they want to do an action on. I then clone that recordsource to rsSalesOrders. The other recordset is SalesDetails (and related data).
|
| Use Enter Key in addition to Command button? | 08 May 2008 00:31 GMT | 10 |
I have a command button that brings up the next form using an entered Last Name to select the records. Is it possible for me to also use the Enter key on the field where I have entered the Last Name to bring up the next form? Thanks, Sherry
|
| Get my form into MS Office Access Objects | 07 May 2008 22:02 GMT | 1 |
I have designed a new form in Access. But when I go to VBA I do not see it listed in Project Explorer under Microsoft Office Access Objects. I can open/display the form with doCmd.OpenForm, but that does me no good. I need to open the form in code view so I can attach code to ...
|
| Combo Box from SQL Server | 07 May 2008 20:58 GMT | 6 |
Attempting to populate a combo box from an SQL server with multiple fields. Returns fields with all empty spaces. Example: SELECT dbo_tblPeople.IDPeople, [LName] & ", " & FName & " " & MName as Name
|
| Refresh tables code | 07 May 2008 20:26 GMT | 1 |
Hey - I'm fairly new to programming, and I've written this code to simply refresh the ODBC and Access BE tables I have in my database. Can anyone see anything wrong with it? It works fine, but almost seems to simple. 'Refresh Tables Code Start
|
| Avoid Bloat in linked DBF | 07 May 2008 19:45 GMT | 3 |
Hi. I have a linked dbf to my Access 2003 database. I have some code which I want to clear the dbf's records (Delete all records) and then rewrite them using ADO's Execute method using the currentproject connection object with some INSERT query.
|
| Importing Stock Prices | 07 May 2008 18:20 GMT | 5 |
Is there some way that I can import current stock prices in access?...I know that there is a way to do it for excel so I am hoping that there is somekind of similar code for access.
|
| How can I replicate a BE database | 07 May 2008 18:18 GMT | 11 |
I have a replicated db which I would like to split in to an FE & BE. Currently command buttons allow the user to send & receive changes from/to their replicas (using JRO coding). It is impossible to create a BE on a server and so the BE will exist on the
|
| Data in Recordset to fill a List Box? | 07 May 2008 17:04 GMT | 8 |
I want to get some data from a table to fill up a List Box... I am using the following code... while.... ObjLista.AddItem rstSQL.Fields(0), 1
|
| Print Dialog Box | 07 May 2008 14:15 GMT | 1 |
I have a custom toolbar that displays whenever a report is viewed. One of the buttons is to print but I need the Print Dialog box to show so users can select a different printer rather than the default. I used "DoCmd.RunCommand acCmdPrint" but when the user prints this it ...
|
| importing new query and report | 07 May 2008 13:49 GMT | 6 |
I created three new fields in a database and then a new query and report based on those fields and a few pre-existing fields. I tried to import the new query/report into a running version of the database (after adding the fields to the table) which seemed to work okay. My ...
|