A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Database Design Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Table Design View by Heather
Hi, I am trying to create a table that I importing Excel data into and the first couple of columns I need to come thru a certain way Booking Qtr should look...
August 12th, 2009 01:48 PM
by BruceM[_4_] Go to last post
8 202
Auto Increment for non integer ? by saleemMSMS
hi i have a table called invoice. the primary key supposed to be not only a number, but also a string. i thought of making the primary key as follows....
August 12th, 2009 01:39 PM
by Klatuu Go to last post
2 215
35 fields by Heather
Hi, is there a maximum # of fields that we are allowed to import into an Access table -- I have 35 fields from an excel table that Access is saying that I...
August 12th, 2009 12:18 AM
by Gina Whipp Go to last post
5 208
Locking form by MMacPherson
I need help! The company I work for has designed a database with a form that you fill out and submit. The form is open to all employees, but for each...
August 11th, 2009 05:25 PM
by Klatuu Go to last post
3 157
Merging information from a table into a Microsoft Word Document by Needing Access
This is an Access question. I have a table of information I need to merge into a Word Doc. For easier dataentry I have used drop down tables for things like...
August 11th, 2009 12:29 AM
by Steve[_77_] Go to last post
4 185
Setting up a db by H
Hi - I need to setup some kind of a database that we update monthly but use the data in Excel and want to find the most effecient way to do this. The data...
August 10th, 2009 05:36 PM
by H Go to last post
2 174
Database Reports - display and access by Bob Waggoner[_2_]
We have used hyperlinks up until the switch from Access 97 to Access 2003 to access our documents/reports from inside the database. Access 2003 doesn't seem...
August 10th, 2009 05:25 PM
by Bob Waggoner[_2_] Go to last post
4 157
Access Developer Extensions and Office 12 by sweeneysmsm
I have an Access database that was designed in Access 2003. I also have the Access Developer Extensions (2003 – 11.0.5622). I just recently installed...
August 10th, 2009 07:44 AM
by Tony Toews [MVP] Go to last post
2 276
calculate tax by Sean
I have a database with a table in it. There are three columns They are Gross, Net & Vat How can I get it to calculate the Net and Vat values by entering the...
August 8th, 2009 05:56 PM
by John W. Vinson Go to last post
3 142
Question about exclusive fields by John Harrington
Suppose I have a table where I want two fields to be exclusive, such that when one field has a specified value the other in the same record cannot take a value...
August 8th, 2009 05:16 AM
by Jeanette Cunningham Go to last post
4 150
Form Design Questions by Damian
It it possible to do something like this: Consider these 4 tables from this screen shot. TblCrew TblJobs TblCrewType and a link table between them...
August 7th, 2009 07:09 PM
by CraigH Go to last post
1 285
Lookup Column to Report by loki[_2_]
I've searched to see if anyone else has this problem but it doen't seem so. So the database keeps track of photos sent to be archived. There is a lookup...
August 6th, 2009 11:24 PM
by Jeff Boyce Go to last post
6 169
Two related select querys in series. How to design tables? by BaBaBo
Thanks @ advance. Got two comboboxes in series. Firs combobox defines skill area e.g. Running. Second combobx uses the value selected in the first combobox...
August 6th, 2009 04:30 PM
by Steve[_77_] Go to last post
6 312
calculating total minutes for each employee by access_learner via AccessMonster.com
I have 3 columns of data. First column has Employee # 2nd column has Code_Name 3rd column has number of minutes The information repeats for each employee...
August 6th, 2009 04:23 PM
by Gina Whipp Go to last post
2 170
Help with validation by Daniel Haley
I was wondering if someone could please help me with validation rules for a table. I am running Access 2003. I have a table called tblSite, which has the...
August 6th, 2009 12:29 PM
by Daniel Haley Go to last post
3 189
Same invoice number- different country by acss
I have an invoice table with primary key of 5 digit text that is unique and i have a (customer id foreign key in invoice table)customer table that primary is...
August 6th, 2009 11:39 AM
by Daniel Haley Go to last post
3 184
Syntax error when using DoCmd.OpenForm by lmcc007
I have a command button that when clicked it will open a form called Check Addresses. Below is the code: Private Sub cmdEditAddress_Click() ...
August 6th, 2009 05:49 AM
by lmcc007 Go to last post
2 164
How do you change the link in a split database by texasyankee
edI created a database on my local drive. I then copied it to a network drive and split the database. On the network drive, I have a folder called TeamDB...
August 5th, 2009 07:13 PM
by texasyankee Go to last post
4 561
Creating a Form by Damian
Can't figure out how to do something. I have two tables: TblCrew cCrewID PK Auto#) cFName cLName cCrewTypeID Numberlinked to TblCrewType TblCrewType
(Multi-page thread 1 2)
August 5th, 2009 09:11 AM
by Keith Wilby Go to last post
16 503
Overtime DB Help Needed by Bill
I'm trying to design a DB that will keep track of overtime hours and date. I have a table of employees, table of equipment they work on and table of date and...
(Multi-page thread 1 2)
August 5th, 2009 09:09 AM
by Keith Wilby Go to last post
15 343
Post New Thread


Display Options
Showing threads 861 to 880 of 11610
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.