Search results

ItemRef to ItemRef

1) Estimate Headers with fields Estimate Number; Customer Code; Created Date; Completion Required Date; Completed Date; Status 2) Estimate Details with fields Estimate Number; Cost Type; Cost Code; Qty 3) Customers with fields Customer Code; Customer Name; Address Details etc 4) Cost Types with...

OK ... so you need to create an UPDATE query where the two tables are linked via Originator ID fields You will UPDATE the blank FullName & EmailAddress fields in the ECN table with the contents of the FullName & EmailAddress fields held in the Employee table. The query could be added to a...

And can the employee create more than one record in the ECN table?

Hi, I think in this reply you actually concede the need for additional tables e.g. "New List" = Estimates; "Client" = Clients I can see what you're trying to achieve but I think you need something above simple but less than super-complex i.e. you need the capability to build up Client-specific...

OK ... just explain to me what the Originator ID is? Is it a unique code assigned to an Employee? It may also help to understand what the ECN table is.

Just to clarify, you want to copy the record containing the three fields into the ECN table once they have been added to the to Employee table? Might first be worth taking a step back from this and consider why you need TWO tables recording exactly the same data ... not a particularly...

If you haven't already adjusted the Print Margins in Page Setup, then try that as a starter. Otherwise, you'll simply have to reduce the overall width of your report by any combination of:- a) choosing a smaller and/or thinner (e.g. Arial Narrow) font b) reducing each field width c) reducing...

Sounds very much like you have got the tables in your query linked correctly ... so I would check these first.

Do the non-alphanumeric characters appear in fixed positions within the text? e.g. always the 5th and 7th characters

That's an interesting project you have there. As a starting point I think you need several tables to form the foundation for a form designed to enter and manage unlimited Estimates:- 1) Estimate Headers with fields Estimate Number; Customer Code; Created Date; Completion Required Date...

You need to start by creating a SELECT query on the DATA table and use =trim(left([Market Code],3)) expression to truncate all Market Codes to just three characters only. The "trim" element will help eliminate any leading spaces in the Market Code. This Query can then be added into a fresh SUM...

Hi Todd ... that code is a little above my pay grade I'm afraid! However what I can add is that we use MFGPRO here at work also, and regularly export TXT files that can then be read/linked into both ACCESS and EXCEL for subsequent manipulation and reporting.

Rather than Import the data, would a linked table perform the same data availibility service to the Access database?

I have in the past hard-coded a User Identity into a 'Licence' table that means when printing key reports it's clear whether the User is in fact the Licensee. Not particularly secure, and certainly doesn't prevent installation, but this seems to have proven pretty effective ... Combined with...

There really shouldn't be any need to update the Total Raised to Date figure ... if you ever need this figure you can it from the Donations table by using a SUM query.

my goodness that's a lot of code for what could perhaps be replaced by a combination of dlookup formula and a form field calculation to display current age ... ?

An alternative idea ... assuming this database is being accessed by multiple users ... read the user's LAN ID and link this to a table that enables/disables the button?

My quick thought is that the common link field, bearing in mind it's a Financial Budget, could be the accounting PERIOD be this a Year/Month/Week/Day or any combination thereof. No need to create meaningless additional codes.

Sorry ... then go Tools>Options>View>Show then untick the Hidden objects option That'll stop 'em!