Help On How To Create A Feild!
Mar 27, 2008
The situation I am in at the moment is that I have a database for a company who does work at different building sites. I have created a database so that it has the date the work was completed. With this company in particular the last possible dates of payment are 30 or 60 days after the work was completed, depending on the work. I would like to know how I would be able to create a calculated field that would display the first day that the payment is late.
View Replies
ADVERTISEMENT
Dec 1, 2004
Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???
Thanks Very good forum
Pete
View 4 Replies
View Related
Nov 28, 2004
I have a form and subform which have the total value of subscriptions made for the month on them.
The subform has the individual values, and the mainform has the total value for that month.
how can i then assign the value of a feild on the mainform, to a value in one of my tables?
whats the best way to go about it?
thanks
BB
View 4 Replies
View Related
Apr 12, 2006
I have have 2 feilds in my database, there can be the same value in one feild but not both.....for example say NAME and ADDRESS i can have the same NAME for more then one entery and i can have the same ADDRESS for more then one entery but i cant have the same NAME And the same ADDRESS....anyone know how to do this? :confused:
View 2 Replies
View Related
Jun 20, 2007
Im having a problem with controling duplicate records in a table
i want to allow duplicates in all feilds individually, but not if 3 feilds are the same in more than one record. (ei. if the entries in a1,b1,c1 are equal to entries in a2,b2,c2; prevent the second record from being entered)
so far, i've writen a macro to identify duplicates in an existing table, but i dont know how to delete records, or access values being entered in a form
any help would be greatly appretiated, thanks
View 2 Replies
View Related
Apr 20, 2006
I have a table (tblStudent) containing a field named fldTeacher1. Looking at the properties of fldTeacher1 I see that it has a lookup:
Bound Column: 1
Column Count: 2
Column Widths: 0";1" (id number; teacher's Name)
I am trying to run a DoCmd.RunSQL command in code and My question is how do I write a sql statement in code that updates that field with a new value?
I have tried:
DoCmd.RunSQL ("UPDATE tblStudent SET fldTeacher1 = " & Val(txtID) & " WHERE fldID = " & gintStudentID & ";")
All it does is place the id # in the field and not display the teacher's name in fldTeacher1 after the command was run.
View 1 Replies
View Related
Oct 27, 2004
I have a feild in my table that I need to increase by 1 each year.
eg.
2004- needs to change to 2005- on 1/1/2005 and keep changeing each year after that.
I am sure this is simple but all my attempts at makeing a counter have failed thus far.
View 5 Replies
View Related
Apr 28, 2008
Hi,
I'm trying to create a table which needs some feilds to be automatically filled up when the control goes to it. Say my table has feilds, "size" and "result". In each row, the result cell should be filled up corresponding to the size value of that row. This needs to be looked up from an existing table.
Would appreciate any solutions!
View 1 Replies
View Related
Mar 19, 2005
I have been struggling with this and would appreciate any help. It sounds so simple!!! I have 4 fields (Unit Price 1, Unit Price 2, Unit Price 3, Unit Price 4) in a Orders table that I want to add together and store in a 5th field (Sub Total) in the same table using a form. I am having problems with the sum and I am unsure how to get it to show in the Sub Total box in the form as well as the table. Thanks for your help!!
View 2 Replies
View Related
May 13, 2014
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies
View Related
Oct 31, 2013
I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
View 7 Replies
View Related
Oct 30, 2007
a system for my company. I have been working with Access for a total of 3 days now, so bear with my inexperience.I have a table with State, Product Name, and so on as Column headers. I have repetition in both of those Columns (if that matters). I would like to figure out how to be able to pull up (Search, Sort, not sure how to word it) 1. By state) all products offered in that state and related info2. By Product) all states using the selected product and related infoWhich would be better for the above goals - Form or Page?I have looked into cascading combo boxes....it that the right direction?
View 2 Replies
View Related
Oct 26, 2006
I have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different entries in the system which i need to keep but i want to assign that contract number with its own ID so i can provide a better contract count instead of it appearing 6 times.
View 1 Replies
View Related
Jul 4, 2005
I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work.
This is what I got:
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.
So installed office XP and tried the same steps but still not working.
View 1 Replies
View Related
Sep 5, 2005
I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled)
Its disabled I cannot continue so no error message. Any idea?
Prodigy
View 2 Replies
View Related
Oct 25, 2005
I would like to create a new folder with a specific name.
example
I have a k: drive where i want the new folder created
I want to name the new folder under the k: drive.
Im sure this is very easy to do, but i can't seem to find an example in the forum.
thanks in advance
View 1 Replies
View Related
Nov 9, 2005
I would like to create a new database from an existing data base with the same fields but I don't want the data. Can anyone give me a step-by step instruction. I also want to duplicate the form as well.
I am currently using ACCESS 2000
View 5 Replies
View Related
Dec 20, 2005
Hi,
I have two tables i would like to create a relationship with but the two fields that i want to join are not exactly the same e.g
Table 1
0000111111
Table 2
111111 ABC
The key piece of information that i would like to link together is the 111111, in SQL i would just type "WHERE Code LIKE '*111111*'" or something like that.
Is there anyway i can create a relationship based on the data above?
Many thanks
Tim
View 2 Replies
View Related
Dec 29, 2005
I am trying to use the following code to export a table into a new spreadsheet that does not exist yet:
DoCmd.TransferSpreadsheet acExport, tbl_temp, "C:Spreadsheets" & rst!clientid & ".xls", True
but it won't work because the spreadsheet doesn't exist. How can I make Access create the spreadsheet?
Thanks in advance!
Vassago
View 3 Replies
View Related
Feb 3, 2006
Can MS Access do "create view"?
CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;
When I put it in the SQL View in the query, it does NOT run.
I put it in modules, it doesn't run, too.
Thanks.
View 1 Replies
View Related
May 8, 2006
This has got to be a really easy one for you guys...!
I need to record the date/time a record was created - I've tried to use now() but obviously that updates and there appears to be no function for create date...
Can someone help me out please?
Thanks!
Katie
View 2 Replies
View Related
May 23, 2006
I setup my security (or lack there of, hehe) and split the database. I relinked the tables.
Now, Access gets hung up when I try to create an MDE of the FE to distribute. It starts the process, asking me to select a folder and file name, I do that, and it gets no further in the process. Access says (not responding).
Should I have created the MDE before I split it? Or does crashing of Access have nothing to do with whether i create the MDE before or after splitting?
View 2 Replies
View Related
Jun 15, 2006
Hi All.
I have searched forums......honest!! But cannot find an answer.
I have the following code to make a directory....the directory name is as the ID_number....
---------------------------------------------------
Private Sub Command216_Click()
Dim strDirectoryPath1 As String
strDirectoryPath1 = "\server1Helpdesk_Calls" + CStr(Me.ID_Number)
If Len(Dir$(strDirectoryPath1 & ".", vbDirectory)) <> 0 Then
MsgBox "The project folder already exists, the folder will now open"
stAppName = "C:Windowsexplorer.exe \server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
Else
MkDir (strDirectoryPath1)
MsgBox "A folder has been created on the network at location \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
stAppName = "C:Windowsexplorer.exe \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
End If
End Sub
------------------------------------------------
This works fine, and makes a directory on the network drive i.e
\server1helpdesk_calls123456
My question is, how do I also make it create directories under this one i.e
\server1helpdesk_calls123456Emails
It is the ID_number that is throwing me....have tried with numerous goes!!
Many Thanks.
Frank.
View 2 Replies
View Related
Jul 22, 2006
Is there any way of adding export fuction to the toolbar using modules or macro
or how I can build my own toolbar when will appear in all workstation in the company
View 1 Replies
View Related
Sep 25, 2006
Structure of db
tables
divs(divid, div, div_short, div_num)
subdivs ( subdivid, divid, subdiv)
issues (issueID, issue, issueName, subdivid)
subIssue1 (subissueID, subissue, issueid)
subIssue2 (subissue2id, subissue2, issueid)
resolution (resID, labeltext, subIssueID)
resolutionlink( resID, labeltext, linktext, navURL, suIssueID)
relationships
div and subdiv (1 to many)
subdiv and issues (1 to many)
issues and subIssue1 (1 to many)
subIssue1 and subIssue2 (1 to many)
Now resolution table could have a one to many relationship with either issue table, subIssue1 table, or subIssue2 table. When I go to create any of those relationships, Access won't allow me. Tells me it can't create this relationship and enforce referential integrity.
Possibly I need to restructure my database to accomodate?
I am not sure, any help would be appreciated.
View 3 Replies
View Related
Dec 7, 2006
Could someone please help me with the following problem.
I have a report that downloads into excel from a loan software program.
The report has lots of data for each individual loan number
What I have done is link this report to access as a table.
The problem I am having is how do I create a relationship with that table.
I want to create a status report that does the following
There are about 15 steps in the loan process, and I want to add 3 fields to link to every loan number (possibly a subform)
description of event
is it completed(y or n)
date completed
can someone please help me with any ideas
thanks
Josh
View 5 Replies
View Related