I'm importing a text file into Access. The file is just a string of numbers that I'm breaking apart into three fields. Once those three fields have been broken apart by the import tool I need to add a new field that just contains the year.
For example, I import the 1990 data file that is .txt format and I break apart the three fields while it's imported. Once imported into three fields, I want to add a 4th field that says 1990 for every record. This has to be a pretty simple thing to do, but I can't figure out how to add a single number as a new field to every record in the database.
Hi again. I finally have time to start working on my access project, and what I want to know is how could a field technician add to access from the field, either with a laptop or possible even a pda. things a tech would need to add are notes, different readings that monitor job progress, equipment placed at the job site, other things like that.
I have created the code below to add a new column to a table each month. This may not be the best database design but it meets our needs for now.
However I am having difficultly with the code below. The CreateField Function is unable to accept the parameter periodDate. Any Suggestions on this would be apprerciated
Function DateField() As Long
Dim colFullName As Object Dim dbsCurrent As Object Dim yearInt As Integer Dim monthInt As Integer Dim table1 As Object
Set dbsCurrent = CurrentDb Set table1 = CurrentDb.CreateTableDef("103TblCustomerBalancesCombined")
yearInt = Year(Date) monthInt = Month(Date) - 1
If monthInt = 0 Then periodDate = CLng(yearInt - 1 & 12) Exit Function End If
If monthInt < 10 Then periodDate = CLng(yearInt & "0" & monthInt) Else periodDate = CLng(yearInt & "" & monthInt) End If
Set colFullName = table1.CreateField(periodDate, DB_TEXT) table1.Fields.Append colFullName
1. I need to know how to update the field list of the query after adding a new field into the table and the query? 2. I need to know how to update the records table after adding calculated filed?
Private Sub subCreateField(strTable As String, strField As String, strFieldType As String, strPath As String, lngVersion As Long)
Dim rstSerial As ADODB.Recordset Set rstSerial = New ADODB.Recordset rstSerial.Open "tblSerial", CurrentProject.connection, adOpenKeyset, adLockPessimistic rstSerial.MoveFirst If rstSerial!lngVersion < lngVersion Then
[code]....
Only the first field ("lngMethodID") gets created. The other two fields ("txtReferencePoint") and ("txtSpaceForPole") do not get created. If I exit the db before each sub call then all fields get added. Do I need to add some "refresh field" action or other action.
I want to add a new field to a table each month end. the name of this field should reflect the previous month. For example when running the update in August 2006 the name of the field should be for July 2006, the format of the field should be as follows: 2006 07. Is there any way to create a function in Access to do this, thanks
I'm adding to a database that someone else set up. I went to the Design View page and clicked on one of the buttons at the bottom to add a text box etc etc. It all looks fine, but the field doesn't seem to be active - if I add some text into it for one page of the databse, the same text appears on every page of the databse. I notice that my "new field" is not listed in the fields list. How do I add it? I keep looking through "The Missing Manual" but without spending 3 days reading the whole thing (which I don't have time for) and learning much much more than I need to know just to get to the part that I need to know, it isn't helping me much.
Please can anyone enlighten me? My email is stu_paranormal@yahoo.co.uk
how to make this two fields in my form to say Y or N if the field is Not Null. Like if the field is not null = Y Else = N for the two fields. I have a picture to show what i'm talking about.
Ok, this may be a ridiculous question to ask, and i imagine there is a simple answer, but i cant see it. maybe its coz i learnt access from the "for dummies" guide :)
i have a table with a "quantity" field. i have a form for finding a record, and then i want to enter a value in a box and press a button to add it to the existing value in the "quantity" field. basically it is for increasing the amount of a certain type of item in stock when a new delivery comes in.
Please help me, im a simple man and havent got a clue
I got a question about a database I'm trying to design. It's a small cable management system.
I want to create a form that shows where the port of a computer is connected to.
For example; A computer has one ethernet port. That port is connected to a switch. I can add the fields for the Unique hardware ID and for the ports of the computer. But I can't seem to chose a device where the computer is connected to.
Ive tried working with queries.. but nothing seems to work so far.
I created a small example of the database I'm trying to make.
The attachment is the database Im working on and I have a problem. I need to add a supplier Product number in there some where so I could keep the numbe as reference and so it may be easier to enter items recieved. in the form section, I will have Invoice with a sub form Invoice details. I need to put suppliers Item number somehow so it would search and if the item is on the product list it would fill out the rest of the values.
should I make a separate table for suppliers product number or should I just include that into the invoice detail? I dont want to put it in the product table since I get same Items from different suppliers.
I hope I can ask this question so that it makes sense.
I have a totals query that I'm using to make a Chart. The query works fine but I want to change the look abit. What I'm doing is quering a table looking for the total number of times that there is a check box in a field called PDC RTA and totaling the Hrs as well. The data comes back looking looking like this. PDC RTA-----Count-----Total Hrs -1 ---------- 6 -------- 53 0 -----------25 -------- 78
My problem is that when I chart this the -1 and 0 show up at the bottom of the bars on the chart. I would like to rename these to fields on the qry qrid then I can chart the new field names so that it will make sense to the user.
I have a field that contains various text....(It's a note field that allows 86 characters).
I want to go in to the database and add the string "Conversion 2007" to the end of every record. So leave whatever is in there but add in the string. I would like it to add whatever it will fit, in the cases where there is not enough room.
I figured this was somewhat simple, but I haven't found anything yet. Thanks.
I am using a Microsoft Access Form and would like to add some new fields and have no idea where to start. Any step-by-step help would be greatly appreciated.
I am an amateur and would need step by step so minute details would be greatly appreciated.
Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:
Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:
I have created a form and now realised that I have forgotten to put in a field. I have forgotten how to add an additional field to the form. Help in plain terms please. Thanks:eek:
I need for a valued to be changed in a row after it checks for how many rows have another value, counting how many and that number making it the amount field.
Example: Fields- Name sponsor amount
I want access to show how many people have been sponsored by Gabriel... So if 3 where sponsored by Gabriel show 3 to the amount field for Gabriel row! Any way to do this or an easier way?
I for it to check it every time a user is added incase the user added is sponsored by Gabriel add it automatically!
I'd like to add a customer type field from my 'Customer:Table' to my 'Customer Balance Report' Also, I need to create a validation rule in my table specific the legal values of SAL, SPG and WMN in my customer type field. with validation text, which I'm not sure how to do.
Can somebody help... I'm trying to put via an automatic way a field to a table that autonumbers. When I use a select-query: ALTER TABLE tablename ADD COLUMN Id Autonumber, Access doesn't recognizes the type "Autonumber". Even in VBA when I use the .createfield method, I can't set the datatype "Autonumber". I'm pretty sure it must be possible (as access can store anyway the indexes.. actually, I want those indexes as numbers in a separate field).
I am trying to add a certain number of days onto a date field to create a due date within a Table but can't work out how to do it. I know that to add days on I can use the function DateAdd but the only way I can see how to do this is to create and update query to run and add the date on. Is there anyway that I can set the field to automatically update the due date dependent on the priority of the record e.g. immediate (1 day) standard (3 days) and request (28 Days)?
So I have a table containing 2 fields containing the first name and last name of a customer. I do need to add these names in the same table into a new field called Name. Can someone help me out?
I am really struggling w/ the following & would greatly appreciate advice!
I want to add several Fields to a Linked Table in Access. The Access wouldn't let me do it because it is a Linked Table. What should I do?
There is also a nicely designed Form that goes w/ that Linked Table. So I figured that once I add the Fields in the Table then I can add them to the Form too. - But can't even add the fields yet....
Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries.
Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries.
