Avoiding SumOf Prefix
Feb 26, 2007I wish to avoid the SumOf, AvgOf prefix in queries. I am aware that I can write sales:sales but in a query with 50 columns that is somewhat annoying.
Any help would be appreciated.
ADVERTISEMENT
Avoiding 20 Levels Of Iif-Then-Else
Mar 14, 2008I'm sure there's an easy solution to this somewhere...
I have a query that is supposed to assign a wage to a production job if the range output falls within a certain percentage range. For example, if they produce 125% to 130% of their goal, their wage is 15 cents higher. If it's between 130% and 135% of their goal, their wage is 30 cents higher. There are about 20 ranges that my bosses want set up. Short of making the longest Iif-Then-Else statement in history, does anybody have any suggestions? Should I use a separate table and somehow try to integrate it into the query?
Avoiding Key Violations On Import
May 1, 2007I have updated a database I created with additional reports, some UI
enhancements, etc., but have not changed anything about the table structure, field types, etc. The database has been in use for about a week by the user and I was working on my local copy. How do I provide the updated database to the user without incurring key violations on the auto-number PKs when their data is imported into the new version?
Avoiding To See Today's Data
Mar 25, 2008I have a query that is pulling data from a table containing a Tamestamp field. I want to set the query to pull my data but don't include anything that was logged in TODAY. How can I set this in my criteria?
Thanks
Avoiding Duplicate Dates
Mar 2, 2005Hi there
I want to avoid duplicate dates in the date field of my form. It's a little more tricky than it sounds though. Imagine two fields in a form; one list box of eleven values and one date field. Once i have chosen a value from the list box i enter the date in the second field. It is ok for one value to have the same date as another value (in another record) but i don't want to have duplicate dates for one value. Any idea how to SIMPLY overcome this problem?
Not really looking to fully understand how it all works, i would be happy just to fix the problem.
Cheers
Avoiding Divide By Zero Error
Aug 25, 2005Hi all.
I have three subforms on my main form. They all display salary details from different sources, and each subform has 2 calculated fields in the form footer to show the average salary and the number of records on which the average has been calculated.
I then have a field on the main form to calculate the average of the averages which works OK unless one of the subforms has null or zero in it, in which case it returns no information.
Can anyone suggest a way of bypassing this divide by zero error? The code I'm using to calculate the average of averages is as follows:
Me!Text44 = ((Me![Frm1 subform].Form!text4 * Me![Frm1subform].Form!Text6) + (Me![Frm2 subform].Form!text4 * Me![Frm2 subform].Form!Text6) + (Me![Frm3 subform].Form!Text6 * Me![Frm3 subform].Form!Text8)) / (Me![Frm1 subform].Form!Text6 + Me![Frm2 subform].Form!Text6 + Me![Frm3 subform].Form!Text8)
Thanks for any help you can provide...
Prefix In A Field
May 31, 2005i have a table of listed documents that when a user enters the data i want the location field to have a prefix before they enter the data so that the tabel field will show the prefix + the data entered
i.e. DocumentLocation ="C:Forms" input data
Any help guys?
Prefix Autonumber
Sep 27, 2007Hi All,
I searched the forum before posting and couldn't find my problem, or how to adapt similar problems.
I have created a Database for call logging.
I have 2 types of call Change and Problem. I have 2 seperate tables for these. Each have an Auto Number as a primary key. One Prefixed with a 'C' and one with a 'P'. This was all fine, problem now being i have created a new table for Time Management.
I am trying to link the the time to a call, i can link the 2 primary keys to the 'reference' field in the time management, the problem being there are now 2, 000001, i can manually re-attach the P or C, but i want to write a report to see who's logging the most calls, to do this i wanted to use the time to look accross to Problem or Change and show the User ID, but when i query C000001, it show's no matchs as all thats stored in the table is 000001.
Any help or advice would be much appreciated.
Thanks,
Ian
Prefix Autonumber
Jan 14, 2008I found instructions that said in order to prefix an autonumber i.e. AAA000 you would have to write "AAA"000 in the format section under the general tab in the table design view of the field you are interested in.
I did this however even though the number now appears as AAA000, AAA001 etc in the table it does appear this way in the form - it just appears as 0,1 etc....
My actual prefix is 2006/1010/ i.e. 2006/1010/001, 2006/1010/002 and so forth.
Anyone have an idea of why not?
Avoiding Make-Table Queries
Mar 28, 2006I have 4 queries needed to power one report. I've tried combining the queries into one so I can run the report off that. However, there is too much data and I get all sorts of errors. My only solution was to toss that data into a table thereby eliminating all the calculations and expressions and cleaning up the data. Is there a more elegant solution to this issue?
View 3 Replies View RelatedAvoiding Duplicity & Referencing Records
Jun 5, 2005Hi,
nuther question from the forum dunce I'm afraid,
I want to ensure the user of the form cannot enter the same [cboPlayerName]
twice for the same [txtMeetDate] (thanks for the advice trubolotta, I changed
the name of the [Date] field.) The user will select the PlayerName from a combo
box. Can I have the list in the combo box diminish by each player as they have
been selected for a [txtMeetDate] I suspect a monstrous amount of code &
intellectual input will be required to achieve this. Basically, what I'm asking
(this time !) is how can I have my program search my tblScratchScores for
duplicate names for the [MeetDate] that I am currently inputting Data for?
Avoiding Make-Table Queries
Mar 28, 2006I have 4 queries needed to power one report. I've tried combining the queries into one so I can run the report off that. However, there is too much data and I get all sorts of errors. My only solution was to toss that data into a table thereby eliminating all the calculations and expressions and cleaning up the data. Is there a more elegant solution to this issue?
View 2 Replies View RelatedAvoiding Duplicate Records Without Using Primary Key
Sep 21, 2015I have a modest sized data base and have been having trouble keeping out duplicate records with the same last name, first name, and DOB. I know I could use all 3 fields as a primary key, but I would like a simpler way of checking for duplicates.
View 3 Replies View RelatedPrefix's For Field Names
Jul 15, 2005I have been looking at the way I name fields and thought I'd Google the topic. Seems to be a split as to prefix names or not. Looks like the SQL Sever and Oracle groups say not to while Access users are kind of directed to use them...
While I have not prefixed names in the past, I was going to do my next db with the things like:
intMyFldName
strMyFldName
etc...
Where as in the past I would do something like:
my_fld_name_one
my_fld_name_two
etc...
What do you all see as some of the pro's and con's?
Adding Prefix To Autonumber?
Jul 27, 2006So I have a table with a bunch of data, InventoryID is the autonumber field which just increments normally, what I want to do is stick 'S000' in front of the autonumber, and for this to be the default prefix for any new items in my database - how would I go about this? I'm guessing some kind of append or update query would do it, but I'm no access whiz, help appreciated folks.........
View 2 Replies View RelatedPrefix To Auto Number
Feb 28, 2006I have a database with a field called "Drawing Number".
I can set it up so that the prefix "STD." always appears and then I type in the relevant number.
BUT I cannot figure out how to set up autonumber so that the "STD." appears and then the auto number is added????
Autonumber With Customized Prefix
Dec 28, 2004Ok...I've looked at old threads and now I'm more confused than before.
I'm trying to find a way to make my field "PCRTrackingNumber", work like this: 05-0001...05-0002...05-0003...and so on. The 05 represents the year. I currently have the field setup as autonumber, set to Long Integer and increment. Even if it looked like 05-1...05-2...05-3...etc. that would be fine. Basically just looking for a way to add "05-" to the prefix.
I was trying to think of a way to combine a field to the autonumber field and use that instead...but need some help.
Thanks, Jeff
Forms :: Avoiding Duplicate Entries By Same User
Aug 1, 2014If different people will be entering data into a "new donor" form, how do I keep them from adding the same person a second time?
It's possible people could have the same name, and it's possible that two people at the same address could be donors. So I assume I would want a "no duplicates" on the combination of name and address, right? But how to actually do that.
Can Someone Tell Me What This Command/method Prefix Means??
Apr 6, 2006Hi
I am new to VB.
Can anyone tell me what the 'ac' part of a method, such as 'acReport', actually means. I am guseeing it may be something like Active Command or similar.
There is no other reason that curiosity for me wanting to know this...or is there??
Thanks in advance
Prevent Dbo Prefix To Linked Tables
Mar 12, 2008Is there a way to prevent Access from the absurd notion it needs to concatenate 'DBO_' as prefix to tables linked from SQL Server db? :mad:
Thanks.
Tables :: Add Prefix As Month Number?
Jan 18, 2015I want my JobCardNumber field in table T-JobCards to add automatically month number.
e.g. For January
1-00001
1-00002
1-00003
For February
2-00001
2-00002
2-00003
OR
Jan14-0001
Jan14-0002
I know the method of setting format in tbl as 000 etc.. but this is one specific.
Modules & VBA :: Using FSO To Write To Text File - Avoiding Conflicts
May 21, 2015I have a function to write some data to a text file (as an activity log, separate to the live data contained in the DB)
It uses the FileSystemObject.OpenTextFile method and works fine
However, I'm conscious that, although perhaps unlikely, there is the possibility (which is enough for me to worry about it) that multiple users could trigger the function simultaneously, which could cause a conflict when multiple FE's try to write to the same log file at the same time.
So I'm trying to add some code to prevent this from happening, by checking if write-access is available before proceeding.
Below is the piece of code I've added. Was considering, as an alternative, looping until the objFile is no longer Nothing, rather than depending on the Err.Number?
Code:
Dim objFSO As Object
Dim objFile As Object
On Error GoTo ErrorHandler
...
Set objFSO = CreateObject("Scripting.FileSystemObject")
[Code] .....
Tables :: Avoiding Currency Format When Storing Amounts
Feb 15, 2013I want to store currency amounts but not use the currency format. My DB is set to use all currencies and provide in all currencies.
Do I use the SINGLE data type?
DB Design To Eliminate Duplicates While Avoiding Compound Key Fields
Nov 10, 2013I'm getting back into Access after retiring and about 10 years of isolation (from Access). I have 2010 version and know that one should avoid duplicate entries and a way to do this is make those fields unique key fields. I have a Customers table and have bounced back between CusID (AutoNumber) and Compound Keys (CusFName and CusLName) as the key fields. The compound keys prevent duplicates but become very hard to work with later in code and expressions. The CusID is preferable from that standpoint, but can't prevent inadvertent entry of duplicate names.
View 2 Replies View RelatedAdding A Prefix To A Field With The Click Of A Button
Jul 19, 2005Getting better - but still far from being competent with VB can someone please help me with the following code.
On the On Click event of a command button I want to call up a field (from another table/form) and add A to it so it lands in a text box. So using the following example -
The table/form is called Patient and the field in question is URNumber. The form I want to put the command button is called RelatedDetails, and in a text box (IDNo) I want to put code that creatsed URNumber with an A on the end (or the beginning) Any ideas?
Queries :: Auto Invoice Numbering With Prefix
Jul 29, 2014How could let me get auto invoice number.... like press Button or combo box??
Here we got some related info: 10 customers, each I'd like to get invoice number with their own prefix, example ICP, CUC and etc...
Then, I would like numbering to be incremental from each customer, mean: CUC001, CUC002, then, ICP001, CUC003 and so on...
When I need to put these invoice number into Data Entry table which like below:
Load Date>>Customer>>Particular>>Quantity>>invoice No
1/Jan/2014>>ICP>>part A>>100>>ICP001
3/Jan/2014>>ICP>>part B>>200>>ICP001
5/Jan/2014>>CUC>>part C>>50>>CUC001
18/Jan/2014>>CUC>>part B>>200>>CUC001
23/Jan/2014>>ICP>>part C>>50>>ICP001
I could not use 'Auto Numbering' for each line, as I need out some lines accumulated for one invoice number 'ICP001'.
My questions:
1. What can I do to let me Automatic generate invoice number which increment from last number?
2. What can I do to let me easy to put those 'invoice number' into my Data Entry table's invoice number field? (p/s: Append Query? Update Query?)
3. What if I need sorting (example to group ONE customer and ONE Particular) for my invoicing number? What I meant is ... let say there is 30 lines customer CUC with particular Part B in a same month, and I wanna get them into same invoice number.