Search results for query: *

Access 2007 log in form - ado connection to SQL2005 trying to see if user is in table and if match then open form if not after 3 times exit app Using a WHERE statement but I am not getting any error if user does not match Private Sub cmdLogIn_Click() 'Check to see if data is entered into the...

Access2007 front:I want make a log in form (frmLogIn)and validate the userid and password against the the SQL2005 table (tblUserList). How would you suggest this being done? I have messed around with a dlookup statement (with no success) but wonder if a SQL statement would be better. after...

This is probably a common thread posted 10 times over..... access 2007 I have a main form with a list box with 5 columns (one columnis unique_ID), of which a user would select the row to be updated with several text boxes from the main form I've tried several things that I have searched out...

Access 2007 I have a form that consists of a request date, supplier, and a txtbx_numberrecords to be added to request_table. I want to add 5 records from the form which includes today's date, supplier "A" 01/14/2009 A 01/14/2009 A 01/14/2009 A 01/14/2009 A 01/14/2009 A currently the cmd...

return the value The query only returns the dates where sales have occurred. I want to be able to the sale pattern for the entire year. column A is a date (every day of year) column B is a date (only days that a sale occured) column c sale amount corresponding to date in column B a...

I apologize for not really having a subject. Windows XP home edition with problems. Only apps on desk top will open clicking the "start" button and selecting an application does not start. I noticed when I tried to go to explore, after I right clicked, it looked like it was going to open then...

When fields from a asp form are inserted into a table, can the date and time of that insert be inserted as a field with it. example: table field name: ProductName, Produced, DateProduced, DateEntered row: Part1 1000 01/06/2005 01/07/2005 09:42 AM

The following code was provided by a book that I am using. I want to learn how each statement works first before jumping into a application. In ASP pg 1 a dropdown box is dynamically populated and a user will select a store id Error on ASP pg 2 Procedure 'CountStoreQty' expects parameter...

Acrobat 6.0 can I use javascript to redirect from a pdf to a web page on our intranet? I'm probably posting in the wrong forum. I want the page to "expire" or "refresh' every 8 hours incase the pgf has changed. Thanx for your help,

New to forms and VB Access2000 I have a form with a listbox containing 4 columns and 5 different suppliers from SupplierTable(SELECT SupplierTable.VendorID, SupplierTable.Supplier, SupplierTable.Vendor, SupplierTable.PO FROM SupplierTable...

New to forms and VB Access2000 I have a form with a listbox containing 4 columns and 5 different suppliers from SupplierTable(SELECT SupplierTable.VendorID, SupplierTable.Supplier, SupplierTable.Vendor, SupplierTable.PO FROM SupplierTable...

CR9.0 from SQL RH PH GH1 - grouped by Product id D - Lot# Quantity GF1 - Sum of Quantity by product id RFa - Grand Total RFb - subreport (archived info w/ Prodid, lot, quantity) Basically trying to combine a archived report with the current report to get total quantity by product id and...

CR9.2 SQL7 db 1 group on prod id design: RH (time and date) PH suppressed Da (prod id and specs) and sub1 linked to specs Db (sub2 linked to specs in (Da) exceptions from sub1 Dc (shared numvar sub1 and sub2) to calc weight formulas Dd (yellow) RF suppressed PF filepath and page 1 of 57...

CR9.2 SQL7 db 1 group on prod id design: RH (time and date) PH suppressed Da (prod id and specs) and sub1 linked to specs Db (sub2 linked to specs in (Da) exceptions from sub1 Dc (shared numvar sub1 and sub2) to calc weight formulas Dd (yellow) RF suppressed PF filepath and page 1 of 57...

New User (pup). I have searched for a way to insert text either where it should have been generated in a subreport or at the end of multiple page report. I was thinking of insering another detail section, typing in the information needed and then try to find a way to get it to show only once at...