Tables
in [Access]
|
Stephan Leban Background gradient problem I am new to Access and had some difficulty with step 10 of Stephan Leban's background gradient procedure. It turned out that placing the event procedure in the On Open Form property would not run. When I opened his example form, I noticed that the event procedures for the background gradient form were in the O... 26 Jun 2008 09:27
How do I split my database for multiple users in Access 2007? I have designed a Access 2007 database to be used by multiple users. Some users will need edit/add capability and some will only have view capability. The database will be put on a LAN. I figured the best route would be to splt the database to BE and FE, then create 2 different FE; view only and edit. Probl... 26 Jun 2008 12:34
network setup I have DB1, a database that has my tables. DB2, a database that has my forms and queries. The tables for DB2 are linked to DB1. Computer1 is the server. DB1 resides on computer1. DB2 also resides on computer1. When I open DB2, the forms work fine. Now if I go to computer2, I have 2 options: 1) Create a s... 26 Jun 2008 23:53
Multiple requests from one table. I have fairly complicated database set up for construction management. I am having a problem with one new report that I need to generate. One of my tables is "Customers". From this table I need to fill in each of the following sections for the Owner, General Contractor & Customer Rep.: Name, Address, City, ... 25 Jun 2008 20:10
Linking tables Which datatype is best to use for the fields used in linking tables? I know Long integer is a good one. Will a text type of 10 characters work okay? Thanks. ... 26 Jun 2008 16:41
How Add Row Number Have a large Access table 3 million rows. I tried to add a row number field but get an error "File sharing lock count exceeded...". Should I be able to do this? ... 6 Jul 2008 12:59
Rooms reservation DB - any help? Hi all I'm working on a rooms reservation system based on Access 2003 and then realize an ASP web page to manage it. I need a little help in creating the DB since my ideas aren't so clear. First of all what I need is very simple: - I have two rooms and I have to let user reserve time slot of 15 minutes ea... 26 Jun 2008 11:32
sharing databases I am sharing a database over a workgroup - local machines have a copy of the database with tables linked to replicated database residing on a common shared machine. I have mapped appropriate network drives on local machines. Everything was working fine but now all of a sudden, unbound combo box with a linked t... 25 Jun 2008 11:54
Calculating age Hi, I need to calculate a persons age on a form. I have tried an unbound text box with: Diff2Dates("ymd", [DOB], Date(), True) entered in the control source but i only get an error message. Is there an easy way i can do this with using VBA? I have a DOB text box. I need to show a persons age in years and months... 25 Jun 2008 09:51
Automate digital signing of PDF documents using Access 2003 I have an application that exports Access reports to a PDF file format using conversion code from Steve Lebans. At the end of the day, a number of PDF files exist in a "To Be Signed" folder. After the user then reviews the reports, I would like to have a process kick off near close of day that looks for the pres... 24 Jun 2008 18:31 |