Hello, I'm currently working on automating the import of a csv file (which works fine using the Transfertext method) but the csv file does not contain field names.
I want to rename the fields with something meaningful after importing the file, but I can't seem to figure out how to do this using the tabeldef method of handling tables. There's nothing in the help, not that I could find anyway.
Does anyone know whether this can be done and how, cheers.
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 made the novice mistake of originally naming a field street #, so I changed it. I went to every place I thought it might affect and still it will not let me access my forms. Is there anyway to find all of the locations it might be and remove it? I am using Access 2010
I was working on my DB, cleaning up some of the field name that were cumbersome and everything worked fine. Today I was doing some follow up work and I cannot change the field names. All I want to do it change the name of a field from CITY to City, but it won't let me do it. I have tried, change from single click to double click, but I was already using double click to open an object; unchecked Auto-Correct, still nothing.
Yesterday I was able to modify a name from Actions to Action (simply deleting one letter. And State/Province to StateProvince. Worked fine. What bothers me is that I have been able to change a field name before and now I can't. I have tried compact and restore, etc.
Hello everyone, I hope I’m in the right forum for the question I’m asking.
I’m using MS Access XP with Sql Server 2000 in an Access ADP. I am still designing my Sql Server database and recently I deleted field called “EmpStatus” from my database. When I tried to open the table I got a message that the field “EmpStatus” could not be found. I tried refreshing the table names and reconnecting to the database but neither of those options work and I couldn’t open the table. I finally had to add the field “EmpStatus” back to the table before the table would open.
I experimented with this problem and found that if you change a field name or delete a field in a table either by using enterprise manager or the Access UI, that table will no longer open in an Access project. I even tried creating a new ADP using the same sql server database and that table still l wouldn’t open.
Can anyone explain to me why this is happening, what I doing wrong , or how to get around this problem?
Hello everyone, I hope I’m in the right forum for the question I’m asking.
I’m using MS Access XP with Sql Server 2000 in an Access ADP. I am still designing my Sql Server database and recently I deleted field called “EmpStatus” from my database. When I tried to open the table I got a message that the field “EmpStatus” could not be found. I tried refreshing the table names and reconnecting to the database but neither of those options work and I couldn’t open the table. I finally had to add the field “EmpStatus” back to the table before the table would open.
I experimented with this problem and found that if you change a field name or delete a field in a table either by using enterprise manager or the Access UI, that table will no longer open in an Access project. I even tried creating a new ADP using the same sql server database and that table still l wouldn’t open.
Can anyone explain to me why this is happening, what I doing wrong , or how to get around this problem?
In the Contacts database, in the Report Center form are 5 links on the right pointing to some default reports.I have created several more reports, and want to just copy-n-paste those links and then change the 'Tag' so it will point to my new report.Can you not just copy-n-paste a field within the same form?
I’m developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. There are 16 different “Events” in all.I currently have the following tables set up:
tblClaim ClaimID ClaimNumber fkEmpID
tblEmployee EmpID EmpName
[code]....
What I need to do is create a form where management can choose two or more events, and calculate the average number of days between two of any of the events, for an employee, or all employees.I have created a crosstab query to change the values in the EventName field in tblEvents to field names, and the EventDate as values for the related EventNames. I created another query based on this query to do the DateDiff.
I created combo boxes on my form with the Row Source Type set to Field List, for a list of fields in my crosstab query. I’ve tried to use the following DateDiff function to get the days between the two fields selected in my combo boxes:
But I get an error about unrecognized field name or expression for my combo boxes. So I added my combo boxes in the query parameter window, with a data type as both text and value, but with both I get an error “This expression is typed incorrectly or is too complex to be evaluated.” I also specified the column headings in the crosstab but I still am getting the “too complex” error.I’m pretty sure it’s trying to do a Datediff on the literal values in the comboboxes and not recognizing that I’m trying to specify field names.Is it possible to assign field names in DateDiff this way?
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 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 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 would like to have a listbox that contains all of the fields names from a table. Since the user will be selecting items from this list box, the field names should be referred to by their captions as defined in the table.
The listbox values will change depending on the value selected from another listbox.
Question: using code, how can I fill a list box with field names and display the field caption?
Microsoft OLE DB Provider for ODBC Driverserror '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Description One LIKE '%flip%''. /sbs/search_prods.asp, line 22
I know that it's becuase the field name is Access is "Description One" as opposed to "DescriptionOne" or "Description_One".
The problem is that I can't alter the actual DB table (it is part of another system that I'm attempting to integrate the site with). Is there anyway to write a query statement that will allow for field names to have spaces in them?
The last line is the problem. A field name in an ADO recordset is limited to read-only persmissions for opened (already exisiting) recordsets. link:http://www.w3schools.com/ado/prop_name.asp
Is there another way around this without using an SQL "ALTER" statement. In other words, by accessing the field's name through a number like rs(i).name instead of rs("fieldname").name?
is there any problem with fields in differnent tables that have a field name that's the same? My concern is the control source for a bound control. Access can keep track of this if a few of these similar field names are on the same form and bound?
I am trying to make a new form with the same info as another but in a different view for easily updatable forms/reports. The current table i have looks like this:
Company Product Market Available? 1................1................2..........yes 1................5................2...........yes 2................1................1...........yes 2................2................6............yes
etc... with the numbers linked to tables with the actual name.
what i want to do is make a table with field names that correspond the different products so that it looks like this:
Ive played around with crosstab queries but I'm not getting the results i want. Is there any way to have this new table linked to my first table so that if theres a new product # entered it will automatically make a new column on the new table and fill it in? Let me know if this is too confusing, Thanks for your help.
Here is my problem. I have created a dbase that takes a download of financial data on a four weekly basis to produce an report for my users. The data always comes across with the same numer of columns but at each four weekly period the date moves on. To show this data in a meaningful way I need to change the field heading automatically, based on the date in the data to show the current Period and Year. The dates given in the download cannot be used as the field names as they are not in the correct format.
How do you display the names of field for a table in a combo box. I know how to do it in mySQL "DESCRIBE employee_data", is there a SQL command in access to do this?
I am having a problem running a piece of SQL code for a multiselect box that needs to run a query to generate a report, i think i know what the problem is but cannot get passed it and i really need to. I cannot change the field name because it is linked to another db that is for other business use. Here is the code :
Private Sub response_Click()
Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String Set db = CurrentDb() Set qdf = db.QueryDefs("responsecodes") If Me!response.ItemsSelected.Count > 0 Then For Each varItem In Me!response.ItemsSelected strCriteria = strCriteria & "MAXIMO_V_WORKORDERS_FA.WORKORDER-RESPONSIBILITY = " & Chr(34) _ & Me!response.ItemData(varItem) & Chr(34) & "OR " Next varItem strCriteria = Left(strCriteria, Len(strCriteria) - 3)
End If strSQL = "SELECT * FROM MAXIMO_V_WORKORDERS_FA " & _ "WHERE " & strCriteria & ";" qdf.SQL = strSQL End Sub
The dash between WORKORDER and RESPONSIBILITY is the problem but that is the field name, when i run the query to hold the data of the multiselect box it hold the data but put's the following statement into the query field name, so i cannot access this in my report query.
What i need is for the [MAXIMO_V_WORKORDERS_FA] to be the table name and [WORKORDER]-[RESPONSIBILITY] to be [WORKORDER-RESPONSIBILITY] to be the field name then i know it will work.