I use something like this to include a Field from a non-linked table to insert information into a Text Box on a report.
=Trim(DLookUp("[Field]","tblName"))
Field is the field name in the "table that contains the field.
I have used a Combo box with a Query input that has added the Last Name, First Name, MiddleInitial and suffix if any and also included the Member or Record number to the same lookup field. Adding the number to the search field will show them separate in the drop down. Simply adding the first...
Following up on the above post.
Have you tried this. With the report in design mode, click on file, Page Setup and check the margins on the left and right, you might change those to .25 each and see if that solves your problem.
This one opens an .exe program from a VB form with a command button.
Private Sub Command1_Click()
MyAppID = Shell("c:\Program Files\Your.exe", 1) ' Run All Reports
AppActivate MyAppID ' Activate Microsoft
End Sub
I don't know what is causing your memory error, but I was able to open an Access 97 database and by pass Access XP by changing the shortcut to something like this.
"C:\Program Files\Microsoft Office 97\Office\msaccess.exe" "C:\your folder\yourDatabase.mdb"
Office 97 is in the folder as...
There is reference to adEditNone, adEditInProgress, adEditAdd and adEditDelete in the ADO help on MSDN disk 2. That doesn't mean it is avaialble for use with VB6 but as I have used only DAO I can't say for sure.
Sorry if I have mislead anyone. I just looked at the help file
If you haven't solved your problem yet you might check the VB online help and look at .editmode. I have used indexed textboxes with bound columns and used locking to prevent input until a button was pushed to unlock when placed in .edit mode then lock again when .update or .cancle update was...
On my XP Pro machine I ran the Network Setup Wizard and created a Diskette and set up my XP home computer that way. You might be able to run the Network Setup Wizard on the XP home machine and make it work that way, but diskette was easier for me.
VB .Net is the new version. I think VB6 will be around for some time to come, however if you plan to do programming for a living .Net will probably be the way to go. I don't think learning VB6 would be a waste of time. What you might try is to uninstall VB6 and MSDN then re-install VB6 when...
Click on Add/Remove Programs, Click tab Windows Setup, Click on Communications, Click on Details you should find it there. You will probably need the ME CD.
If you have the bootdisk or a windows 98 or ME bootdisk, boot up with it then at the A: prompt Enter C: then key format c: and answer Y this should format the Drive
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.