hi,
i'm trying to create a form for data input. When creating a new record, I want to make a field, "Date," to read from the last record and use that value as the default value. This way, I don't have to input the same date in every time I make a new record. How would I do this? Thanks =)
G
Expressions in Access have given me some trouble before. Mainly due to inexperience. I hardly ever work with them. What I am trying to do is make the default value of a form textbox control the minimum value of a field A in a table A. The datatype of Field A is Date.
So far I've got:
=Min([table A].[field A])
In the Default Value of the form's property sheet, but this just returns a blank value. I've had a look in the table and there is no value that is blank in field A.
;) Hey everybody,
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
Thanks
gunwax
Hi Everyone,
I hope someone can help.
I have a form with a combo boxes and a table with relevant list and additional field, fldDefaultDrive (Yes/No Field).
Currently in order to set the default value, I have used the following code for each default;
Private Sub Form_Load()
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """D"""
End Sub
However, I want users to be able to go into the table and change the default value if thier CD player default Drive is anything but D: Drive. I have tried to replace the D above with an SQL statement but with no success.
Private Sub Form_Load()
Dim Drivename As String
Drivename = SELECT tblMediaDrive.fldDrivename FROM tblMediaDrive WHERE (((tblMediaDrive.fldDefaultDrive)=-1));
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """Drivename"""
End Sub
This is definetly not working, can anybody help, I have a feeling it is syntax but not sure where? :confused:
Robert88
On my database I have a text box that accepts a map grid that starts with two letters. If the letters arnt within certain perameters then the box turns red and a message box appears informing the user of this. My probem is that I am using a continuous form and if one box goes red, they all go red if the grids are OK. my code is below, can anyone help?
Private Sub Grid_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Grid) Then Exit Sub
If Me.Text289 = "UK" Then
Select Case Left(Me.Grid, 2)
Case "ST", "SY", "SU", "SZ"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
If Me.Text289 = "Germany" Then
Select Case Left(Me.Grid, 2)
Case "MB", "NB", "NC", "MC"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
If Me.Text289 = "Desert" Then
Select Case Left(Me.Grid, 2)
Case "NJ", "NH", "NK"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
End Sub
i developed a program and i used ms access for the database.
i compiled the program i made.
the question is, can i install the program i made into another computer eventhough it doesn't have a ms access? because i tried to install but it doesn't work at all. what do i need to do in order to make it work.
your response is greatly appreciated.
I am not sure where to post this so could someone please move it to the appropriate area thanks.
I want to make a graph that will show how many employees are in the company for each year (Going back 10 years and keeping up to date) I have never done this before and our teacher feels that its best if we learn on our own (basicaly he's an idiot).
How do I go about using the pivot chart?
I have made a query which adds up the total number of employees at the current time.. but apart from that I havent a clue. I want the graph to have the years on the bottom and numbers up the side (1,2,3,4,5 etc) and then the number of employees that were in the company during that year will be plotted.
I will use a table that is to be used for archiving to mke the query as it will have all the employees who were ever in the system record.
The table is thus:
Employee_ID
Emp_First_Name
Emp_Surname
Age
Emp_Home_Number
Emp_Mobile_Number
Emp_Address_1
(so on and including postcode)
Date_Started
Position_ID
I have no idea what to do other than to rename the axes and change the increments, but they are jsut numbers, no dates or anything.
Any help apreciated.
Does anybody know if its possible to export data from Access into a "filename.LEX" file for use in MS Word?
If so - Do you have any idea what the fieldnames/file structure looks like.
I have tried oipening a .LEX file to check this out, but with no success.
Thanks
Hi guys,
I am having error message when I tried to make my mdb file to mde. The error message is "MS Access unable to create an MDE database". Reading through the help message it says that this problem always occurrs in trying to compile large db into MDE. So what can I do to solve this problem. Also what is MS access memory capacity. thanks
:mad:Is there anyway, I can tell who is making my backups. Is there any thing I can use to find out who is creating a backup. I have sent out emails to the users, but no one will confess who is doing yet. I have 200 users now. I have talk to our IT people, they mention it would take a lot of there time to track it down.
Does anyone know if there anything I can do?
Thanks
Hi!
I have a table called "products"
One column is "Unitary Price", another one is "Quantity" and another one is "Tax"
And I want another column called "Total" that shows:
Unitary Price*Quantity+Tax*Price*Quantity
Is this possible to be made?? :( I'm a bit newbie to MS Access, so try to explain as most detailed as you can! For example, if I have to write [Unitary Price] between brackets... I tried doing this on the "Default Value" field of the column but I couldn't make it.
Thank you!!
Luis
I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like:
A 2 3
B 4 6
C 2 5
D 3 5
E 2 3
How can I leave row 1 out? So that the query will look like:
11 19
This is probably a stupid question but could you please tell me how i can set up a form in access to look similar to the one in the attached picture?
View 4 Replies View Related:confused:
Hello I have a small DataBase with 4 forms (Access 2002)
1. frmMainMenu
2. frmAddEmployee
3. frmAddEmployeeRegion
4. frmEmployeeStatistic
The MainMenu calls the other 3, when I execute the mde file the only form opened is the frmAddEmployee! it should open the frmMainMenu because this one calls the others....! I've tried several times....the same result!
Any idea what I'm doing wrong?
Thank you
How can I make an OLE come up in the report as a photo or drawing instead of a link?
Can anyone help?
I need two reports made but I don't know the programming. The first report comes from a table that has contact numbers and their scan times. Their number comes from one column and their times come from another column in a table that i have. the time comes in this format 6/11/2007 3:46:40 AM. One report I need is those who just scaned in for that certain day. The second report is one to take their times and calculate how long they were scanned in per day, and per week. Is there any such way to do this and how would I.
View 12 Replies View RelatedGood evening,
I am trying to use VBA to address a field in three different subforms on a form. When I am in the VBA environment writing the code, I noticed that only two of the subforms are listed in the Project window on the upper left. I ignored that and wrote the code anyway, and when I execute the code, it works fine for the two subforms in the Project window, but when it gets to the third subform, it throws this error:
"MS Office Access can't find the field '|' referred to in your expression."
The code is this:
Private Sub Test_Number_AfterUpdate()
[Form_Consumables Entry].Test_Number.DefaultValue = [Form_Test Director Panel].Test_Number.Value
[Form_Squawk Entry].Test_Number.DefaultValue = [Form_Test Director Panel].Test_Number.Value
[Form_Event Log Entry].Test_Number.Value = [Form_Test Director Panel].Test_Number.Value
End Sub
Can anyone tell me how to make all of my forms available to VBA?
Thanks!
Erik
Hi
Any one has idea, how to make the project unviewable.
When you right click on any module, form or class in Project Explorer instead of menu, a message "Project is unviewable" should be displayed
rahulgty
I am looking to design a simple stock database for work. This is just an idea at the moment, unless I can get my head round this problem.
I have throught that I can have 3 tables
NEW STOCK(this is where you enter all new and existing stock is)
USED STOCK(this is where all the stock that has been sold used for whatever reason is entered)
ACTUAL STOCK(this is where the items in NEW STOCK have the items sold in USED STOCK deducted from them to give you the ACTUAL STOCK)
PLEASE HELP ME, am I completely on the wrong line or can I do this?
Would be good if I didnt have to use SQL, VBA etc...
I have a form which I need to make read only. On Access 98 it used to ask how I wanted to open and view the form in edit mode or view. I cant find this option in 2003 anyone got a quick answer? Many Thanks
View 6 Replies View RelatedI posted this in the wrong thread yesterday
I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct code in the format field:
"Not Completed "[Red];" Completed "[Green]
This worked for different field before I created the split form but now I cannot get the new field to display anything but check boxes regardless of what code I use. It won't even let me use the default yes/no, true/false or on/off options.
I've been studying this for about 2 weeks and I've figured out quite a bit but this one thing is really iritating me....
Help
Any comments would be appreciated
John
Hi!
I'm working on a Access 2003 mdb file. I want the database to start commonly without any user-login screen.
Nevertheless I want to prevent the default logged in user from making any changes to the database structure, using the tables and examing the VBA code.
Because of some strange guidelines I have to respect those changes have to be directly made to the mdb file itself (if possible) so no additional worgroup file is created.
Is it possible to realize it that way?
Thanks!
Hi guys,
Does anyone know how to turn a query into a table? There is like 400,000 records in my query so the easy copy and paste option won't work.
Any help would be greatly appreciated,
Aidan.
Hello,
I'm creating a database for a home builder to track a lot of info, but mainly: house info, prospect info, actual customer info, and contract info.
My main tables are:
tblCustomers
CustID PK
(a bunch of customer fields)
tblHouses
HouseID PK
(a bunch of house fields)
tblContracts
ContractID PK
CustID FK
HouseID FK
(a bunch of contract fields)
The releationships are as follows:
One house can have many contracts
One customer can have many contracts
I thought I could use one table, tblCustomers, to track the prospect info and actual customer info, as so much of it will be identical (technically someone should be entered as a prospect before they can be a customer, and all info will be the same for both except for extra information fields for prospects, but I always want to be able to refer back to those fields) and I would know a prospect became an actual customer because at least one contract in the tblContracts would have their CustID associated with it.
Is it acceptable to have two foreign keys in tblContracts? And am I missing something that should exist between House and Customer? House and Customer are only releated when there is a Contract, so it is implied (I think) that a Customer can be associated with many different houses through many different contracts. Is that the right way to look at it?
I've come up against a wall regarding linking two forms so that the second form displays the data associated with what was showing on the first form. If I'm good here with the tables I suppose I'll post my detailed question in the forms area.
Thank you so much!:o
~Merissa
I know this is probably a stupid question and I'm overlooking something obvious, but... I have a Long Integer field that has an input mask requirement of 7 numbers. Sometimes the number starts with a 0, but instead of showing as 0468165, it shows up as 468165. I want the 0 to show at the beginning. How can I do this? Thanks!
View 12 Replies View RelatedI,m trying to create mde file but a dreadful error mesage appeared :(
Here it is:
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
My database is not AS LARGE. It has 1 table, 36 queries and forms.
Any idea how this could be avoided?