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

Highlight A Feild

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

Setting Feild Value To Table Value

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

Allowing Duplicates In One Feild But Not 2

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

Duplicate Feild Issues

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

Update A Lookup Feild

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

Changeing Feild In Table Annualy.

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

Auto Complete Feild In Table

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

Adding Feild Values And Storing In Another Field In Same Table

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

Forms :: How To Create A Form That Can Edit Or Create A Record

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

General :: Create A Button That Will Create A New Empty Backend

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

Im Trying To Create...

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

Create ID

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

Cannot Create An MDE File

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

Unable To Create MDE

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

Create A New Folder

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

Create A New Datebase From An Old One.

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

Relationships? Anyway To Create These Using SQL?

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

Create New Spreadsheet

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

Create View

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

Create Date

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

Create MDE Before Or After Splitting?

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

Create Sub Directories

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

Create My Own Toolbar

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

Won't Let Me Create Relationship

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

How Do I Create This Relationship

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







Copyrights 2005-15 www.BigResource.com, All rights reserved