Retrieve A Value From A Previously Inserted Row

Feb 19, 2006

Hello,
Im using a ASP and MS Access 2000 database. What im trying to do is: I insert a row into a table, in that table is a field that auto increments. after I insert this row I want to immediately after that be able to retrieve the value of the column containing the auto increment and hold it in a variable so i can use it for other things....

can anyone help me with this? I have been messing around with SQl cursors but cant seem to get it to work right..

Thank you very much
-Justin B.
Edit/Delete Message

View Replies


ADVERTISEMENT

Combo To Show Only Those Not Previously Used

Apr 26, 2005

Hello,

I apologise if this is a common question, but I didn't really know how to word the search!

I have a form with a person selector combo, and an asset selector combo. I would like the person combo to show everyone, but the asset combo to ONLY show those that havn't already been assigned to someone else.

Any ideas?

View 4 Replies View Related

Populate Field From Previously Entered Name

Mar 17, 2005

I have a form with a text box that the user enters their name into. When they click submit a menu form is opened. I want the name that was entered to be carried over to a field on the menu form. This will welcome the user, eg: WELCOME John Smith.

Im thinking that i should use the INSERT INTO function, but im not sure of how to go about it.

View 2 Replies View Related

Simple Question Probably Asked And Answered Previously

Sep 12, 2005

Trying to fix a simple problem with some tables.

In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later.

In essence we had 2 databases of the same information going for a while. Now everyone has the same database. Problem is the following:

Simply put:

We have 10,000 records autonumbered in one of the databases. The other database has 9,500 with the last 100 or so being information that the 1st database does not contain. How can I update my main table to have all 10,100 records? I have tried an append query and it doesn't seem to be working right. I have also tried to 'find unmatched' but can't seem to make that work either. There has to be an easy solution to make it work in one step.

Any help would be great. Thanks in advance. :confused:

View 1 Replies View Related

Make A Field Equal To What Was Entered Previously

Sep 20, 2006

I think this should be simple, but my mind just isn't functioning today. I have a form that people have to enter information in every hour. It has a lot of repetitive information to be entered each time, for example, they are supposed to enter their initials or name so that we can track them down if there is an issue. Is there some way, to make that field on their entry form, equal to the previous entry? Thank you!

View 9 Replies View Related

Tables :: Display Names At ONLY Location Previously Selected

Jul 7, 2014

I am making a database, but lets say I have 12 locations and have say between 2-100 named people at each location.

I want to be able to link 2 databases together.

I can use lookup wizard to select either a location, but I also want access to display the names at ONLY the location previously selected (IE: Paul and Bert are in Brazil, Steve and Carl are in Cuba, I want once Brazil is selected only Paul and Bert to appear as options). I'm sure it's fairly basic but a having a little trouble with it, and not knowing the technical terms is making it hard to look up.

View 1 Replies View Related

Access 2000 - Previously Saved Data Will Be Deleted

Aug 13, 2013

i am programmer i do a project on vb.6.0 and ms access 2000

PROBLEM 1). .if i try to save data on the database its successfully saved but previously saved data will be deleted.

PROBLEM 2). if i add large number of data on database but its not increasing and constantly on 18 numbers.

View 4 Replies View Related

List Feature Based Upon What A User Previously Typed?

Nov 20, 2013

I have a subform containing maintenance logs for pieces of equipment, viewed as a Datasheet.

I have a field called Comment accepting text. Since comments are similar, it would be nice to have a drop down list so the user can select what was previously typed in other records and then edit it from there, similar to how Google or search engines in its search text box generates as part of its suggestion list the previous searches after typing in the first few matching characters.

I tried looking through, but is there a property that does this?

View 3 Replies View Related

Queries :: Pass TempVar To Query That Is Selected From Previously Opened Form

May 23, 2013

I'm trying to create a query that supplies a form with data. I want to pass a TempVar to the query that is selected a from previously opened form.The TempVar is setting correctly and I can see if this if I place a textbox (NewCID) on the form showing the TempVar. The problem I have is displaying on the records according to that TempVar. If I set the query manually, i.e. "|Test|" then records are displayed but if I use the TempVar, which also displays |Test| then no records are brought back.

think it's something do with the vertical bar and that fact the field I'm searching on is a memo field, both of which I've no control over. I also have to use the Like statement because of this.Here's the query that works...

SELECT *
FROM dbo_ASSETS
WHERE ASSET_CID Like "|Test|"

and the one that I want to use, that doesn't...

SELECT *
FROM dbo_ASSETS
WHERE ASSET_CID Like [TempVars]![tmpvarCID]

I've even tried referring to the textbox instead of the TempVar, i.e.

SELECT *
FROM dbo_ASSETS
WHERE ASSET_CID Like [Forms]![AssetsCID]![NewCID]

but that doesn't work either.

View 2 Replies View Related

Combobox Value Inserted As ID#!!

Aug 23, 2005

I am just starting with access and I have a VERY stupid question. I made a combobox (it gets its values from a table with 2 colums the first the ID and the second is the products) when a user selects one of the products in the combobox the combobox is supposed to update another table with that value (and I mean the product name) yet what it updates is the ID # of the product that was selected!! How do i go around this.
I am new to access so i am not sure how things are done yet in access, i am pretty good in VBA in excel, but this is a new front for me that I am trying to learn. I did the above combobox using the wizard.

Layth

View 2 Replies View Related

Forms :: Query Using Table - Indicate Previously Input Data In Case Of Duplicate Entry

May 30, 2015

table name : Schedule
Field 1 = Vessel code
Field 2 = Voyage
Field 3 = ETA
Field 4 = berthed
Field 5 = Sailed

there is a query by using above table and data entry form based on that query.

need to add following facilitate

While data entering, if given voyage number is already exist for the particular vessel code, msg should be pop up immediately at that time saying " This voyage number is already exist"

How could this be manage ?

View 4 Replies View Related

Subform Inserted Into A Form

Jan 5, 2007

I have a subform generated by a query, I then have a double click function to run a further query this works when I open the subform separatly, but if I open the form and then double click on the field in the subform this will give me a error!

View 5 Replies View Related

Primary Key Inserted In Another Table

Feb 18, 2005

Hello I have another prob. I need to be able to take a new ID from the topics table and insert it into the messages table after a form has been posted. I haven't got a clue on how to do this.

Its for a message board where a new topic is inserted. Two tables need to have records inserted, the topics table and messages table. The Topic_ID from the topics table is an autonumber and needs to go into the TopicID field in the messages table. Here's my insert query:

sqlString = "Insert into Topics (Topic, BSection, Username, MesDate) values ('" &_
Topic & "', '" & BSection & "', '" & Username & "', '" & MesDate & "')"
Con.execute(sqlString)
sqlString2 = "Insert into Messages (Username, Member_ID, Topic, Message, MesDate, BSection) values ('" &_
Username & "', '" & UserID & "', '" & Topic & "', '" & Message & "', '" & MesDate & "', '" & BSection & "')"
Con.execute(sqlString2)

I've tried using the identifier command but that didn't work so I haven't got a clue on what to do. Can anyone help?


thanks


Grant

View 14 Replies View Related

Modules & VBA :: How To Get Last Inserted ID In A Table

Sep 10, 2013

I have this code in Access VBA and it is not working.

Private Sub btnAddWorkingday_Click()
Dim strSQL As String
Dim strDate As Integer
Dim lastID As Integer

strSQL = "INSERT INTO tblSchoolWorkingDays (CALENDAR_DATE) VALUES ('" & tBoxDateToAdd.Value & "'); SELECT @@IDENTITY AS LastID;"

DoCmd.RunSQL strSQL
End Sub

View 7 Replies View Related

Unexpected Row Inserted In A Code Table

Jun 22, 2005

I have the following tables, tblAudit and tblCriteria. The first records companies and period of audit, the second contains the criteria against which they will be audited. The audit period determines which criteria apply.
Results are recorded in a third table, tblAuditResults.

Relationships
tblAudit 1:M tblAuditResults M:1 tblCriteria

My problem is when I try to add a new result by selecting a criteria via a combo box a new row is inserted in the criteria table as well as in the result table. Inserting a row in the criteria table is wrong.

I have attached the database for you to look at.

Thanks for any advice you can offer.
Fearless

View 3 Replies View Related

Getting The Properties Of The Record Last Updated/inserted

Apr 27, 2006

New here, looks like a great resource.

I have a question about a form which has several fields on it. What I need to do is to capture the ALL the fields of the record I just entered(updated or inserted)

So, for example, if my form has fields for

RepID, RepName, Company

After I edit or insert a new record, when I click to the next line, is there a way I can use AfterUpdate event to capture ALL the fields that were just updated on the form, and do whatever it is I need to do with them? I hope I am amking myself clear. Thanks for taking the time to look.

View 6 Replies View Related

Queries :: Use Inserted Value Dynamically At Run Time

Oct 16, 2013

I am inserting a new record into a 'master' table. Primary key is generated using a sequence. Now using that newly inserted primary key value, I need to insert a new record in child table. These 2 insert queries need to run at the time of deployment. how shall I store that primary key in a variable so that I can use it immediately in next insert statement?Can I use a returning into clause?

View 2 Replies View Related

Tables :: Text Automatically Inserted?

Apr 24, 2013

I have a table of nursery school children, names, addresses etc etc. One field is Under 2? Is there a validation rule (or something like) that will automatically put Yes (or No) depending on today's date and the child's date of birth?

View 6 Replies View Related

General :: VBA Select Query With Inserted Value

Feb 13, 2013

With the following VBA code, I'm trying to select the text value from a textbox and fill that in a query to select the code from a person. (a password only login).

However, I'm getting a run time error 3078 at the '' Set rs = db.OpenRecordset("strSQL")'' line.

Code:
Private Sub Tekst6_AfterUpdate()
Dim strSQL As String
Dim strBarcode As String
Set db = CurrentDb()
'strBarcode = Me.Tekst6
'MsgBox strBarcode

[Code] .....

View 8 Replies View Related

Forms :: Tax Calculation Cannot Be Inserted In Database

Oct 17, 2014

I have created a From with some Fields: Name, Surname, Netto Price, Tax (%) and Gross Price..... to make a invoice.

The Problem is that i cant insert the data from: Tax and Gross Price in to the DB.I have tried this:

select Tax Field--> Property Sheet -> Control Source: =[Price]*0,19

example:
Netto Price: 100
Tax 19%-- =[Price]*0,19 = 19

Now I get the correct values ​​displayed in Field Taxes.But this this sum cant not insert in to the Database.I use MS Office 2013.

View 9 Replies View Related

Text Box Expression Inserted To Table?

Mar 13, 2012

I have a text box on my table form with the expression =([LINES]-[MISSED LINES])/[LINES] which gives me the results I want but I also want this total to go to the "On time %" column in my table.

View 3 Replies View Related

Wrong Year Inserted From Calendar Control

May 31, 2006

Hi there,

I have used Calendar controls before but this is a new one on me?!
When i click on the Calendar, what i am doing is inserting the date clicked into a textbox on another form.
The Calendar is set to todays date the system date is also correct and although i click on 31/05/06, what is being inserted is 31/05/20 ?????

Any ideas, because i dont?

Thanks in advance

View 5 Replies View Related

General :: Why Space Inserted When Export Report To RTF

Oct 22, 2012

I am exporting a report from access. The problem is after export to .rtf, all fields appears correct except a bar code field (CCode39). It adds a space after the text which makes text non-recognizable by bar code scanner.If I use other formats, then there is no problem. I tried by using plain text as well rich text format for that particular field.

View 1 Replies View Related

Modules & VBA :: Email Address Inserted From Non Related Table

Sep 4, 2013

I have a table that holds company information for the user - eg farm name, company name, manager, phone number and email address etc. Its simply used to provide headers for reports, so that the same generic database can be used on several farms. There is only one record in this table tblfarmdetails.The second table tblorder is for orders and receipts - I currently have code that allows the user to send an order request by email to the manager, and to also send notice of receipt of goods through to the manager. I would like the code to get the email address from the unrelated table.Can I reference this field in the vba?

Private Sub cmdemailorder_Click()
Dim orderdate As String
Dim stafford As String
Dim item As String
Dim itemamnt As String

[code]....

View 8 Replies View Related

Tables :: Calculated Form Field To Be Inserted Into Table

Jan 3, 2013

i want to insert a calculated value of a e.g field6 (field4 * field5) in forms into the database table. by using expression builders in my forms. i have made that feild and on click it shows the calculated value but on filling in the rest of the form and clicking on Insert button does not update this calculated field but iserts all other fields.

View 3 Replies View Related

Forms :: Table Inserted Into Form No Longer Expands After Db Is Split?

Aug 20, 2013

I have elected to have tables inserted into my forms. For example on the School Information form, I have the Employees table inserted at the bottom so that it will show the employees that are assigned to that school when it's pulled up.

Before I split my database into a BE/FE situation, I could expand the items in the tables to other related items, but now that option is gone.

Is there any way to get that back with a split database?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved