Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Change in Database 1

Status
Not open for further replies.
briglass

briglass

Programmer
Dec 4, 2001
179
GB
I get an error when my Visual Basic project reaches this line:

dbNames![id] = idchange

it also doesn't like

dbNames![id] = val(idchange)

I must not be doing this right, any hints?
 
Sort by date Sort by votes
Hi!

We need a little more information. What is dbNames, [id] and idchange? It may be easiest to just post the code you have.

Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
'(id is a field of the table Names)

set dbNames = db.OpenRecordset("Names", dbOpenDynaset)

inputchange = Val(InputBox("What number?", "Change", dbNames![id]))

dbNames![id] = inputchange

'or

dbNames![id] = Val(inputchange)


Make sense?
 
Upvote 0 Downvote
Hi!

Yes this makes sense, try this:

dbNames.Edit
dbNames![id] = inputchange
dbNames.Update

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
334
Moss100
Moss100
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
207
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
scamquist58
  • Locked
  • Question
Change Access Default Printer 1
Replies
8
Views
529
scamquist58
scamquist58
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
286
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top