Description:
Microsoft Office Access newsgroup.
|
|
|
Format of temporary variables
|
| |
I have a pointer stored in TempVars!MyIndex Within DLookup( or DSum( references to TempVars!MyIndex work fine but IIf(tblField = TempVars!MyIndex, does not work. As a work-around I tried this: Dim NewIndex as Integer NewIndex = TempVars!MyIndex IIf(tblField = NewIndex, and found it works well.... more »
|
|
|
how to best structure this?
|
| |
i am upgrading a cost calculator from excel to access so need some advice on the best way to structure this please!? i'm starting with one spreadsheet called Linehaul Costs, which details the breakdown of the costs and the total calculated cost to get to each destination. i will describe how my excel table is set up first: at the top of the table... more »
|
|
|
Need a little help with syntax
|
| |
Hi Guys, Having a little problem with some code. I'm wondering if anyone with a keen eye can point out my error. Private Sub Transaction_Type_AfterUpdate() If Me.NewRecord Then Me.invID = Nz(DMax("[OrderID]", "Orders", "[Transaction Type] = 2"), 0) + 1 End If End Sub I want the text field invID to update once a transaction type is selected.... more »
|
|
|
Store similar types of records all in one table or separate tables?
|
| |
Suppose you want to have four different types of records. Each of these records have numerous fields in common, and a few fields that are unique to each type of record. Most of the fields are related to other tables, but a few are simply text fields or Booleans. Which is better?: Keeping track of all 3 types of records in a single table.... more »
|
|
|
(Object invalid or no longer set)
|
| |
My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's... more »
|
|
|
Field Privacy
|
| |
I have a database that I need the SSN number for employees as the key. I want to make it so I can input the SSN number when I add an employee but make it so others that need to veiw the database can not see the number. How can I do this? Thanks
|
|
|
Date Format
|
| |
I want to have my report display a date format for example 11-05-09, i want it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out if I try and format this in the table or the report ot the query that generates the report. Thanks
|
|
|
Show employees and others in combo box
|
| |
I am trying to figure out a way to show employees and non-employees in a combo box. The training database includes training records. Training may be conducted by either employees or outside people. It is easy enough to make a combo box showing employees, of course. The EmployeeID number would be the bound column. I suppose I could make a table... more »
|
|
|
Appending table autonumber problem
|
| |
I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990?
|
|
|
Invoicing database design
|
| |
I am designing a database that includes the simple (!) functionality of producing invoices (not an accounting package). I understand the convention is to have a table for invoice headers and one for invoice transactions. My question is what are the advantages of this approach rather than just having one table for invoice transactions. The... more »
|
|
|
|
