New profile posts

What's new Featured content New posts New profile posts Latest activity
J
Can you delete me from the forum?
NauticalGent
NauticalGent
These posts are not private, EVERYONE can see them. You can also delete your account on your own.
M
Hi Dave. Just tried to post a question on the VBA section and got a message saying it could not be posted because it may be spam etc. Any guesses?
Gasman
Gasman
Contains a link?
A
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 🌹 🌹
Gasman
Gasman
Crossposting in Profile Posts. :(

That is a first. :)
J
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.
T
(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
D
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.
1
Hi @arnelgp, I find your help for @Mercy Mercy here

Solved - Print selected invoice

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 =...
www.access-programmers.co.uk
  • Like
Reactions: AccessBlaster
View previous comments…
1
113hans
Sorry, I don't have permission to write more than 420 characters, so I reduced my message to small parts, sorry If this bothers you.
Gasman
Gasman
PMFJI,
You should start a new thread. :(

However look at the WHERE parameter of the OpenReport command.
1
113hans
I will post a new thread, thank you for your attention.
G
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.
1
Dear arnelgp, warm wishes to you on the Christmas!
I was lucky to have you help me 2 years ago.
Now I posted the subject

Help with creating a button to export PDF file

Hi guys, wish you all a merry Christmas! I know on the Print Preview, we can create a PDF file through right click and choose "Export". But on the Table, I wonder can we make 1 button which automatically does 2 things: 1. Exports the PDF file to a folder on our PC 2. Names the exported file...
www.access-programmers.co.uk
Click to expand...
Hope you read this and give me a hand, thank sir.
arnelgp
arnelgp
if you can "show" the supposed pdf to create (what info is in the pdf).
also can you post a sample db with same table you want to create pdf, individually.
1
113hans
Here my sample db, thank you for your attention.
1
113hans
I mean I posted on the thread

Help with creating a button to export PDF file

Hi guys, wish you all a merry Christmas! I know on the Print Preview, we can create a PDF file through right click and choose "Export". But on the Table, I wonder can we make 1 button which automatically does 2 things: 1. Exports the PDF file to a folder on our PC 2. Names the exported file...
www.access-programmers.co.uk
Back
Top Bottom