I have a text field in a table .. I would like the default value for that field to be the machine name. How do I do this? I know how to set a default value for a date or piece of text. I imagine it would be something like: machinename(), that's about as far as I get.
View Repliesok im making a database for a tumble prosses at work
first problem:
i have a yes/no field in a table "pull ontime"
witch i want to be controled by "pull actual" witch it a time filled in with the now() comand trigered by a button in a form i want to make the "pull ontime" field read no if the time is over 1hr over a value "pull" and read yes if under this 1hr
second problem:
there are machines that are loaded with parts i want to make it so when they enter the part # and the s/o # and stuff they will hit a loaded buton witch i want to make it put the Now() time in the "Loaded" them based on the operation witch has 2 cycles witch depending on the operation the first cycle could be 2 hrs and the 2nd could be 1.5 hrs i want it to based on the operation selected set the time that the oporator has to change the cycle "rinse" and "pull"
Hi, I would like to recreate a record locking problem (error # 3218) our users are experiencing on an application we have developed. I currently do not have access to a network, so I would like to run multiple instances of Access on one machine. How do I do that?
Thanks,
Bill
Hi,
I´ve installed office97 professional on a computer with office 2003 standard on it.
When I try to start access it tells me there is no license for it on the machine.
Has anyone else had this problem? Of course I have a license, and there has never been any problems with it in the past.
The 2003 version has not yet been registered, if that might have something to do with it.
Fuga.
I'm needing a pop up adding machine that will copy and paste a calculated value into a text box on a form when the calculator is exited....much like banking teller's have on their transaction pages.
View 1 Replies View RelatedAm fairly certain that I will be asked to design and implement a Machine Status Application.
Description below is very simplistic but believe you will get the idea
Basically simple stuff at Machine Operator. He clicks a command button on a display that signifies machine is okay or not. This updates machine status. Image it just toggles between Running and Stopped.
Each minute little process runs to at 1 to Run value or to Stop value. Okay so this will get a little more complex for sure.
Now I could end up collecting data on say 100 machines. Okay so I would not expect the status change to occur any more than once per hour on average so it would be a bit like having 100 very very slow users on the system.
Now the crunch. What effect (if any) would these 100 very very slow users have on performance and particularly the One much quicker user who is executing preset queries one after another for say 20 seconds every minute.
Thoughts and opinions welcome
Len
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
Hi,
I'm trying to establish the link from my local mdb to an mdb on a commercial server I'm using.
The problem is there's no way to locate the remote access database when using the Link Table wizard.
Anyone knows how to establish that connection??
Thanks in advance!
I recently bought a new computer and it was kinda cheap, so no office products were installed on the computer. A friend loaned me her copy of Office 2003 which didn't have Access on it. So, after installing Office 2003 I picked my old Office 97 CD and installed just Access 97. Then I go to open the database and get this annoying message.
Microsoft Access can't start because there is no license for it on this machine.
Can anyone help? Thanks for your time.
Hello, I'm a newbie at using access database on local machine.
I have worked with it before on a hosted site ,but need to know how to go about using it to host my database driven site on my local pc.I'm using maxwebportal ,which I have been using for a few years, After I install iis on my winXP Pro pc ,what do I have to do for my database to work,? is there something that I need to enable? thanks for any help Aussie )
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
I am facing a issue in accessing my db file in server. I just splitted my database into front end and back end , placed in a local folder which is shared in network . I opened the files in network from my colleague machine and everything was working fine yesterday .. but right now i am getting error like "the network path is not found " 0X80070035 which tells that check whether the source machines is able to accept file sharing ..I googled and tried 2 solutions Like turning off windows firewall and enabling NetBIOS Over TCP/IP..
View 10 Replies View RelatedI have a query which is currently using a prompt box to ask the user to input a machine number. This is run from a button on a form. Press the button and the prompt appears .I would like to now do one of two things either make a form with every machine number on it or use a combo box to select the machine number. My problem is that I don't know how to get the combo box or the control button to link to the individual machine number.
View 2 Replies View RelatedI have developed .net application ....at back end I am using ms access database. When I deploy my application at client end , I want only my ms access database should accessible to application only. Client should not be even to see which type of database i am using or its business logic .
View 7 Replies View RelatedI've been told numerous times that a shared database should have each user with their own FE. I've also seen in a number of places that the FE should be on the user's local machine. Is the FE on the local machine to limit network traffic only, or is there a greater reason for it?
I was under the assumption that the seperate FE's were to lower the probability of corruptions and sharing of local temp files... If this is the case, is it reasonable enough to have each user have their own FE in their own user folder on the network?
Hi,
I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US Passport right under the Photographs and it looks like this
P<USAERIKSSON<<ANNA<MARIA<<<<<<<<<<<<<<<<<<<
0550667081USA6908061F9406236ZE184226B<<<<<14
1st Line
So P stands for Passport and Contry code is USA and then last name Eriksson and first name Anna and middle name Maria.
2nd line
Passport number and Date of birth and sex and so on.
Now I am in process of ordering a keybord that has a MRP reader on the top( http://www.accesskeyboards.co.uk/ATB420%20Reader.htm ) from this company in UK. You can find the specification on the keyboard from the above link.
So as soon as I scan/swipe it, it will give me information in the following format.
FIRST NAME, LAST NAME, DOB, SEX, PASSPORT NUMBER.
SO ONCE I HAVE THE INFORMATION IN COMMA FORMAT, HOW DO I GET THIS DATA INTO MY RESPECTIVE FIELDS INSTANTLY, AS SOON AS I SWIPE THE PASSPORT.
My field name in the table are
LastName
FirstName
BirthDate
PassportNo
MaleFemale
Thanks.
Rajput
I have developed a database in Microsoft Access 2013. I wish to install and run that database on another machine on which I have already installed the MS Access Runtime.
In order to allow the database to run correctly on the target machine, I need to add two Trusted Locations - one for the front-end database and another for the back-end database.
The folder paths on the runtime machine are different to those on the development machine, so how do I add Trusted Locations (on my development machine) which remain valid when the database is copied to the target machine?
Must I trick it by simply creating an identical, dummy folder structure on the development machine (would this even work?), or is there a more elegant way?
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
Trying to use Access97 on Windows XP and I get an error message.
"Microsoft Access can't start because there is no license for it on this machine"
I've tried everything and it still doesn't want to work.
I've uninstalled and reinstalled
I've tried to find the font, hatten, and it's not there
I've downloaded MDAC 2.8
I've check the permissions in HKEY CLASSES ROOT
I've tried c:setup/y
I've downloaded AcLicn97.exe and it tells me that it can't find Access
If anyone can help, please let me know
Dear Sir...:)
Please your help it is urgent for me.
There is to table:
First table name (UserName) with fields:
1- UserID
2- name
Second table (Website) with fields:
1- Id
2- UserID
3- WebSiteURL
And there is one-to-many relationship between them.
what I have to do if any new users register by default; it gives him URL (I have to let default more than one).:confused:
Please your help ASAP.
Regards;
FAIZ
I am trying to set up two date fields in a table, and I would like the second date field to default to the value of the first date field for each record - is this possible to do in the table design?
View 2 Replies View RelatedI want to set the default value on a table to 'Previous'. Basically I want to display the value in the field above it, so say if I have a company name "bobs boats", I want the next company name to default to "bobs boats". Can you do this??
View 9 Replies View RelatedHey,
Ive got a table set up which is not calculating properly (or least i cant seem to get it to) Basically i have a row for quantity and a row for unit price. What i want to do in my table if possible is times the unit price by the quantity so it will come up in my reports which at the moment it isnt doing, as the default value is 0 in my table!
Might anyone be able to help me on this matter?
Thanx in advance
How can I set the previous record as data source for default value in MS Access table?
View 3 Replies View RelatedI have a billing date on my form.
Each billing date should be on the 15th of any month (1/15 or 2/15 or 3/15, etc…)
Is there a way to default a day to the 15th and then make the user enter month and year?
Or if there is no way to default the date to the 15th, may be there is somehow I can check to see if day that user entered = 15th?
Thanks.
How can I Default a Text Box value by the input of another two Text Boxes. This Expression on the Text Box Default Value does not work.
=IIf([Text0]=0 Or ([Text8]="<" And [Text0]=1),"White",IIf(([Text0]>=1 And [Text0]<=49),"Blue",IIf(([Text0]>=50 And [Text0]<=499),"Orange",IIf([Text0]>=500,"Yellow","No Input, left blank")))) :confused:
Other Text Boxes follow, I want to see the Default Value as soon as I leave Text0 and Text8.