Hello my dear teacher DHookom
Can I divide the categories into several tables. For example, stationery - devices - sports equipment
Is there another way other than creating multiple tables and what is it? Please provide an example and I will be grateful
here is the unlocked password.
you can replaced the password on your own.
but the new one i installed is FuzMic, same as your name.
the VBA can be opened.
Howdy - I'm a long-time-ago programmer from the planet named Florida. I haven't done much with Access since 2007, so I'm pretty rusty and I ask dumb questions. Usually I'll be able to find answers on my own, but I'm old and mentally slower now, so please bear with meas I try to wake up my little gray cells.
(I didn't want to write in the thread because this is tangential)
> You may not be able to append an autonumber to a SQL server autonumber field though.
Yes you can, using SET IDENTITY_INSERT ON
Hi Crystal, I've mucked this up. I forgot there was no data in it. I was waiting until I got things right but thats no excuse. I'll put some sample data in it and re post it tomorrow. That's the best I can do.
Hello everyone. I have a slight problem. The following code does not fire to print selected records in invoice. It is supposed to filter the selected records and the studentID Private Sub Command48_Click() Dim sFilter As String On Error Resume NextDoCmd.CLOSE acReport, "INVOICE" sFilter =...
Not sure if you were able to create the Add-In for the VB Beautifier. I faced an error while using it.
1. At Nz(strChangedLine. so I deleted the line to proceed, as the Procedure or Function was not found.
2. You may need to change the declaration "Dim mod1 As Module to CodeModule", the same for any references in sub Procedures or Functions.
With these corrections, it worked well. Thought it might help others.

Reactions: azhar2006