Thanks guys ............ I am working on it right now ... I like to understand what is the object and methods for Currentdb() and if I have a Customer table of 100 rows , if I use a combo box, then I will have a drop down list of 100 CoID, so I thought having the user to type in CoID and press...
Hi,
I am a beginner in Access VBA. I have an unbound textbox on a form. I want users to be able to type in a CompanyID in the main form and then have only those records that match such as Company Name and Address appear in the main form, and the corresponding EmployeesID and Name appear in the...
HI Krishna Kumar,
Yeah you are right, {?SS-SchoolAchievement} is a report parameter field and {StepNarrativeText.NTID} is a database field. When the user key in "40" in the parameter, I want crystal report to retrieve table row with primary key, NTID = "NT2" in table...
I want to select multiple records from Access into Crystal Report, it only displays one record at a time, here is my code:
If {?SS-SchoolAchievement} < "40" then {StepNarrativeText.NTID} = "NT1" else
If {?SS-SchoolAchievement} >= "40" and {?SS-SchoolAchievement} <=...
Hi,
Is there anyway I can work on an oracle db without logging in as the administrator of the operating system? What is the requirements for running oracle db? I have signed up for oracle online tutorial, but I dont have administrator right at work, what should I do?
Cheers,
Alicey
The other error meq that I receive is:
set 0 fields to null due to a type conversion failure, it didn¡¦t add 357 records to the table due to key violations, 0 records due to lock violations and 0 records due to validation rule violations.
pls help. Thanks.
I have two replicated Access database, one is splitted and the other is not. I tried to use the 'Append' function to append data from one db to the splitted db, I receive this msq: duplicate output destination, can anyone tell me how to use the Append function, pls.
Hi jfgambit,
How do you change C:\Documents&Settings\...\...\ to
\\TheNameofyourCompanynetwork\TheNameofYourComputer\YourFoldername\ThebackendDB.mdb name, I tried the Properties of the shared folder, it doesnt work, pls help, thanks.
Cheers,
Alicey
Hi jfgambit,
I tried to add a shared folder on a shared network. It worked well before I split the db. After I splitted the db, where frontend and backend are still on the same folder, I have this message: "C:\Documents&Settings\...\...\ is not a valid path. Make sure the path name is...
What I did was I created a new folder on my machine, right click and select properties and set to 'share folders', and I selected security and added the login ID of other users' machine from there. Then I click on My network place\Add network place and I selected a network which I am using from...
I have created an Access db on shared folder that I created for others to access the db and it is working fine. But after I splitted the db into front end and back end, both sitting on the same shared folder, I cant open it from other computers except the one that I used to create the db. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.