PC Review


Reply
Thread Tools Rate Thread

Get a number from a table to a form.

 
 
New Member
Join Date: Aug 2012
Posts: 1
 
      1st Aug 2012
Hello! I am trying to pull a shipping number from a database table, Shipping, to a form, increment the number for the set of items to be shipped, and add the new items back to the database. I am trying to use DLookup like such:

txtShipNum.Text = DLookup("Shipping Number", "Shipping", "ID = 52")

but it doesn't seem to find "Shipping Number" even though that is the collumn name. I need to pull the last shipping number from the database in one form and increment it to one more, and then push that new number to a subform where I input my data for shipments. Does anyone have any suggestions?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Get ubuntu ! Get ubuntu ! Get ubuntu ! Get ubuntu ! Rich Windows Vista General Discussion 8 7th Jun 2009 06:29 PM
Re: Get ubuntu ! Get ubuntu ! Get ubuntu ! Get ubuntu ! The Seabat Windows XP General 0 2nd Jun 2009 04:32 PM
Re: Get ubuntu ! Get ubuntu ! Get ubuntu ! Get ubuntu ! Mike Brannigan Windows Vista Security 0 1st Jun 2009 11:39 AM
Re: Don't Get ubuntu ! Don't Get ubuntu ! Don't Get ubuntu ! Don't Get ubuntu ! TheBiG Douche Windows Vista General Discussion 0 31st May 2009 10:43 PM
can get page number to display, but cannot get page number to pri. =?Utf-8?B?Ym9jaHJhbg==?= Microsoft Word Document Management 2 26th Jan 2005 01:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:45 PM.