Search results

The user will enter his or her name. I used "Dave" as an example. I've gotten one step closer: DoCmd.OpenTable "ECRlog", acViewNormal, acEdit DoCmd.GoToRecord acDataTable, "ECRlog", acNewRec DoCmd.GoToControl "Originator" This puts my cursor at the field "Originator". Now if I just get the...

I think I'm getting warmer? Here's what I've got so far: ------------------ DoCmd.OpenTable "ECRlog", acViewNormal, acEdit DoCmd.GoToRecord acDataTable, "ECRlog", acNewRec AddNew Orginator, "dave" ----------------- This opens my Table and creats a new record bu tthe last line isn't right...

My form is a textbox where the user inputs his/her name. Now I want to append thier name to the end of my table. I REALLY appreciate your patience with me. Dave

I'm still lost! I've looked up recordsource, recordset and addnew in ther help fils and in "Mastering Access 2000" manual. None helped. Here's a clipping from the Access help file on Addnew: recordset.AddNew FieldList, Values Seems vauge to me, but if I use my example from the original...

Thanks for the help Pdx_man. I'll check into Recordset etc. My expertise (if I have any) is actually designing printed circuit boards. What am I doing here then you ask? Well...Our software uses Visual Basic to extract info from the board design. I taught myself VB to see what I can make it...

Hi all, I have a table (lets call this "TBL_USERDATA") I also have data ("NAME") in a form (FORM_INFO) that the user has entered . When the user clicks on the "UPDATE TABLE" button on the form , I want this data to be appended to my table. Can anyone give me a clue as to how to write this...

Give this link a try for starters: http://www.bo.uiowa.edu/~gldss/DOCS/linkAccess2000.pdf dp

I've never tried it, but I know that it is related to Oracle. You can open tables in Oracle from Access just as if they were Access tables. I would do an internet search on Oracle and see if you can get some more info there. Good Luck. Dave

I have a program that is similar to yours. It helps users create Engineering Change Requests (ECR's). Each user logs into the system and the programs checks the users name and password to a hidden file. Depending on the users access level (level of experience a better term maybe?) then the...

Sara, Uxbridge is due south of Worcester, just minutes from the RI border. It's a nice quiet town, but located close enough to Boston and Providence for nights out. It's growing fast (like most burbs in Mass) very quickly, but I wouldn't mind a settling down here once prices on homes get a...

I'm still a newbie (so go easy on me, eh?) , but, if I had to tackle this, I'd look into storing all those "other documents" in PDF format, then just give a link to them in Access? Hope this helps, dp

Just my 2 cents.... I like WAF.GIF by Audrey. dp

I had considered that, but the Excel file is a huge database with info about 100+ user. I only need the 10 items that apply to the current user. Then I'll need that info multiple times during the program, so it seemed to make sense to extract the 10 items, write them to the table, then goto...

I've read the data into an array (?) called data(1), data(2), data(3)....data(10) But I'll try your ideas instead! Thanks for the help!! :D

Hi all, It's great to have you all back. I got nervous when this site was down for a few days. Newbies like me rely on you guy more than you know! Here's my question: I have a table called tblECR. It has 10 fields in it. ECRno, User and Mgr, as examples. I also have small amount of data that...

I'm new at Access and VB, so I need some help. On a form (called LOGIN), I ask the user for thier name and password. Then using VB, I open an Excel database that contains user info and confirm the password. Also contained in that Excel file is their "supervisors name". Lets assign it MGR$...

Forgive me if this is a stupid reply, but I'm realy new w/ Access so I read all the topics to learn from your questions. Don't you need 2 more "end if's" in there? Looking forward to the answer! Dave

Hi again all, I posted a message late yesterday (~13 below) I've gotten closer to seeing the files in my directory. The following will read the list of files, display them one at a time, but each new filename overwrites the last one displayed. Can I list them one below the other? Please...

Also... Do I need to change my "Row Source Type" or anything?

I need some help. Only a few weeks of Access under my belt so far, and we haven't cover this topic in class yet. I 've found a half dozen methods to read my directory, but I don't know how to pass the data to my form. I use the following lines to read a list of all the files with the extension...