I have a form with several data fields on it. I also have a button on the form that allows the user to duplicate a record . The reason for this duplication is so that if there will be an additional client record for the same customer, but only one piece of data will need to be changed, it's easier to copy the record and then change the one field.
However, I am getting the following message:
"some of the field names you tried to paste don't match fieldnames on the form"
and then not all data in all fields gets duplicated.
I need to figure this out, but am going nuts with it. If anyone has an idea or two they'd care to toss my way, I would be happy.
I am trying to do the following If any one of you have experienced Abacus ticketing system, each reservation is comprised of a group of names as follows
I have to copy the above data from the abacus tcketing system into a text box. My question is how can i devide the above three names into three seperate text boxes.
If 2 tables have a field named 'EmployeeID' (for example), are you screwed when it comes to queries and vba, as far as selecting fields / specifying data goes?
I need an opinion. I'm new to access so I'm really lost I have to create a database consisting of 20 clients. Then they gave me 4 steps I had to accomplish:
Create a total of all account balances, so the total number of recievables are known.
For each account, calculate the number of days each balance has been outstanding.
Classify the account into 4 groups three late (30,60,90 days overdue) and one current (under 30 days), Total the amount of outstanding recievables for each catagory.
Sort using number of days balance is outstanding as primary sort key and outstanding balance as the second sort key.
My question is should I make a field called Days overdue and a separate one for outstanding balance. It also seems they want me to do calculations in the table. I thought that was not an excepted taboo? Are the 4 goals possible to accomplish in access? Please give me some help!
I am creating a query that retrieves data from one table and creates a second table. I want to name the columns in the new table using the contents of the controls from a form within the same mdb. The form will be open when this query is run, but I am having trouble creating and saving the query.
Here is a sample of what I am trying to do...Any help is greatly appreciated!!
Thanks
SELECT IndividualHolidays.SU, IndividualHolidays.SSN, IndividualHolidays.Init, IndividualHolidays.LName, Max(IndividualHolidays.NewYearsDay) AS Forms!HolidayDatesEntry!NewYearsDay, Max(IndividualHolidays.AftNewYears) AS Forms!HolidayDatesEntry!AftNewYears, Max(IndividualHolidays.PresDay) AS Forms!HolidayDatesEntry!PresDay, Max(IndividualHolidays.AftPresDay) AS Forms!HolidayDatesEntry!AftPresDay …<etc> INTO HolidaysByEmp FROM IndividualHolidays GROUP BY IndividualHolidays.SU, IndividualHolidays.SSN, IndividualHolidays.Init, IndividualHolidays.LName;
I have two queries which are both similar. They consist of a list of names with a ‘count’ function to see how many times that the name occurs. Some of the names in the two lists are identical and some are different.
I am looking to create a query (or smoothing) that takes the two sets of numbers, matches them by the name (NameID). If the name does not exist in one of the lists then put a 0 (see example below). Once I have this I then want to create a stacked bar graph to show the results.
My database has FirstName and LastName fields. I would like to initialize a new field called UserID with the first letter of the first name concatenated to the last name. I have found references that point to using Left([FirstName],1)&[LastName] but am unsure if this can be done in the table definition or if it must be done using a query. Either way I could use some advise on initializing this fields since I have 3500 registered users. Thanks
I apologise in advance for my lack of understanding but I need to know whether an access 95 database will accept file name's that are 21 characters long and contain underscore's?
I have never had to get involved ith access database's so far but have been told find this out. Any help would be much appreciated.
I have a query in which I have the name of teams and the names of staff in those teams. I am trying to have a count in my query that counts the number of staff in each team but I cannot get this to work properly. In the same query I have other calculations which sum figures.
I have a firstName text field on a form and a Surname Text field. on the Event AfterUpdate i have this code:
If (Not IsNull(DLookup("[FirstName]", _ "Employee", "[FirstName] ='" _ & Me!FirstName & "'"))) And (Not IsNull(DLookup("[Surname]", _ "Employee", "[Surname] ='" _ & Me!Surname & "'"))) Then MsgBox "Someone already exists with the same name! Please check for duplicates", vbCritical, "IPDMS" Me.Undo End If
I am trying to Check the table "Employee" to prevent duplicate personnel from being entered.
My code at the moment is preventing any duplicate surname, its not combining it with the FirstName.
i.e. any person with the surname "Summers" cannot be entered twice even if they have different FirstName.
About 4500 records in a database have two names in a forename field, I need to split these so only the first name stays there and anything else in that field is moved to 'othername'.
Using Access, and update queries, I just can't work out what to do. Using Query Analyser I can see a logic but can't get the syntax right.
What I need is omething like Code:SELECT * from individuals WHERE forename is like * *Dim pa, pbpa = the bit before the " "pb is the bit following the first " " and including any subsequent onesforename = paothernames = pb Some forenames have simple problems (eg 'John Peter') others are less simple (eg 'Mr J P and Mrs S P')
I have an Access front end linking to an SQL Server back end. My question is: Using VBA, how can I find the Group Names for groups I've got set up in SQL Server?
This should be easy but I can't see how to do it efficiently. I have a small application that books people in for a competition and creates a record for each. At most I get about 500 people registered in a day, I need to be able to highlight when anyone from a specific list of names (no more than about 15 people) comes forward and tries to register. I guess this is some form of CASE statement where I compare surnames against a text array or is there an easier way? ps I don't mind if it's hard coded into the VB code rather than as a look up table. Thanks pps you can do this with conditional formatting but the limit there is three.
I have succeeded (with some help from this site!) in creating a clinical database for the Diabetes Care team in our hospital. Now, our IT helpdesk staff want me to list the field names and data types. The design view of the tables seems to contain everything they need, but I have tried everything and cannot find a way to paste this info. out into any other format, Word, Excel etc. Has anyone ever managed this or is there something else I should do?
I have an Access database that I need to import in to a SIR database that only takes fields names of a maximum of 8 characters long.
I want to create a new database with the same field names, only abreviated, and then import the data from my original database into the Access database with the new names.
Is this possible and could someone give me explicit info on how to do it?
I 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?
I have developed an Access database which produces financial reports based on a date range which the user specifys, taking the data from a SQL server. He chooses his dates and then runs a macro which creates the new tables, overwriting previous tables. Numerous financial reports run on these tables so I need to keep the table names the same.
The problem is that only one user can access the DB at anytime because the new user can't delete the other users table becuase it may be based on a different date range.
I'm open to suggestions but maybe what I need to so is create tables which are based on the user id when he logs in to the Access database so that he doesn't delete someone elses table. How can I do this please!!!???
i have four oracle db'ses mydb_db_test, mydb_db_production, mydb_db_develop
within access i have linked tables from the first one; let's say: mydb_db_test.tblOne, mydb_db_test.tblTwo
What i want to do is: 1) import the same tables from the other trhee db'ses 2) rename the table names by vba code example: my_db_db_test.tblOne has to become tblOne and when i switch from db (to for example the production), the tblOne has to be renamed originally (mydb_db_test.tblOne) and the other has to be renamed (so mydb_db_production.tblOne becomes tblOne).
Now the question which you probably ask me: Why not by a connection string change...
Well, that's the problem, the linked tables are being set to readonly, and the property cannot be changed (at least, as far as i tried); so that's why i thought of this workaround. By linking all three databases, i also always have for those table the three connection strings, and by renaming them (i now do this manually) i always can pick the right connection.