| Thread | Last Post | Replies |
|
| How do I make a Subtitle in Access? | 29 May 2008 16:15 GMT | 1 |
I have small project on access but I have never used it before. What I trying to do I have title (Hot saw), under the title I have to create 5 to 6 sub title(example, 18 Table, 19 Table, etc,.). Now lets say I have problem in 19 Table then I want to write the decsription about ...
|
| Join tables in Access | 29 May 2008 15:29 GMT | 2 |
I want to join two tables . One is receivables and the other is payable. Payable table fields are : Name , Date , Amount Receivable table fields are : Name , Date , Amount
|
| Label Bound to another Label | 29 May 2008 12:59 GMT | 1 |
is it possible to bound a label to another label with a lookup, ie, Label1 = AXY Label2 = 123 whereby there is a table showing that AXY belongs to 123? Thanks,
|
| Cell 1 = row 1 balance minus row 2 balance | 29 May 2008 12:36 GMT | 3 |
I have a table as below, and I want to create a new column NEW: Date A/c Balance NEW 1/1/08 ABC 100.00 200.00 (300-100) 1/2/08 DEF 300.00 -100.00 (200-300)
|
| Invoices outstanding at end of year | 29 May 2008 07:42 GMT | 1 |
I am running Access 2000 on Windows XP. I need to design a query that will give me all the invoices in a database outstanding at the end of the UK Tax year. I can find all the records for the year OK. I have fields for Amount (Amount Invoiced) Payment (payment received) and
|
| Form not allowing updates | 28 May 2008 21:26 GMT | 5 |
when I try to update/edit in my form I get the message, "The recordset is not updateteable" Using Access 2007, on properties it says my recordsource is the correct table, allow edits is set to yes, it is not locked.
|
| read only mode | 28 May 2008 20:56 GMT | 3 |
I want to put my access database on a shared drive in the office but need it to be on read only mode so that no one can play with th einformation is this possible and if yes how? You reply will be highly appreciated.
|
| Tables & Forms | 28 May 2008 19:54 GMT | 6 |
I'm very new to access. I need to design a form that has different sections in it. I know I have to start with building a table but do I put each section in a different table? Then do iI build the form off of all the tables? Thank you in advance.
|
| DateDiff | 28 May 2008 19:26 GMT | 5 |
How would I run a query that would give me the total days in between the original date and the current date? The only date that I have in the database is the original date. How would I tell access to subtract that from the current date to come up with the number of days in ...
|
| conecting to Access Database with excel | 28 May 2008 18:27 GMT | 6 |
In Excel I am trying to connect to a Access database using the New Data Query Wizard When I get to the choose Columns screen and click on the Available table and columns
|
| Max & Min field table | 28 May 2008 14:14 GMT | 9 |
now i have the crosstab query as below. I want, in my report, to show the following below the crosstab query table: ABC ABC XYZ Date 12345 55555 9876
|
| Access 2007 Macro design help | 28 May 2008 00:33 GMT | 1 |
I need suggestions to create a macro that will open a table, go to a record, and then open the attachment of that record. Can this be done???? I currently have many macros that work great, but with the new Access feature that allows attachments to be hooked to a record, that ...
|
| identify employees that have/haven't taken certain training course | 27 May 2008 23:08 GMT | 2 |
I'm new to Microsoft Access and my boss recently asked me to create a 'training database' for our department. The company I work for offers hundreds of training programs and your labor grade depends on which courses you've taken.
|
| Trying to not count duplicates in a report | 27 May 2008 16:32 GMT | 11 |
I am new to Access. I have a field OrderID, I need it to count the total # of orders for a daily report and a weekly report. The problem is more than 1 employee will be dealing with each order (1 employee picks the order, another employee verifies and loads the order on the ...
|
| Calculating Report totals. | 27 May 2008 12:36 GMT | 1 |
Quick one - for those of you who know what to do that is! Calculating report totals for an Invoice. General stuff. Got Page Header, Order id header and detail all working as planned. Need to work out order id footer.
|