Recent content by Paul200968

Hi, I have put the sub whatever under a button of the form which works but where do I put the Private Sub Form time? I get this dialogue box to save this file but no sendkey is sent.. Can you show me in the example location c:\test.pdf in de sendkey part. Im a new with this so any help would be...

How do I install this on my Machine?

Hi, Would it be possible to print a report from access in PDF format to location "c:\temp\" I know this can be done manually by selecting printer "Adobe PDF" but could someone help me todo this via VBA. Idea is that I have this form and when I press the Print button, the report is generated in...

Im affraid that wont work, the data is allready there. Managment only wants to know what kind of "doddgy" information has been added in the free text fields. We were thinking about singe characters, blancs etc. but it would be helpfull if something similair was created or websites in this respect.

Hi all, Employees enters free tekst description of goods in a tekstfield. The question have been asked to query that database to check if they fill in the free tekstformat correctly. I understand that this is virtually impossible but we were thinking abount BLANCS, One character and maybe only...

Dave, I used the wrong field, just spotted the attachment. sorry for this. But when I use top 10 it does not shows 10 records because I have records with same values. Thatswhy I was hopping that I could count the records. Can you help please. Paul

Dave, I've selected the query and properties and entered for example 10. When I re-run the Query, it still shows all the records? Can you help please. Paul

Hi, I was wondering if it possible to add a column in a query which shows the recordnumber of that query incrementing with 1. The reason for this is that I want to create a top 10 (records) I was thinking of a function but Im not familiair with that. rgrds, Paul from Holland.

Hi, I have created a macro with 2 lines: 1) setwarnings is no 2) output to excel file. When I run this marco it will prompt that this file exists. I thought this wasnt the case when you setwarings to no. If I use VB with docmd.setwarnings false it does not prompt me?? Could somebody help me...

Hi all, Im looking for an object which looks like a filebrowser and when I select a file, the path (preferable the UNC path) is recorder in an access database. Currently im typing over the location of a file and record this information into a database. rgrds, Paul.

Hi all, Im looking for an object which looks like a filebrowser and when I select a file, the path (preferable the UNC path) is recorder in an access database. Currently im typing over the location of a file and record this information into a database. rgrds, Paul.

shell string not working Hi, Im trying to get the string from my combobox (which is a field from a tabel) into the shell but it doesnt seems to work. this is the code: Private Sub Combo1_AfterUpdate() 'myfile = "\\Tpghos41data.nl.tntpost.com\occ&sqa$\OPS_Processes\Reports\Awkward\test.txt"...

Hi there, I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved? In addition, I want to startup application with a command line in a access macro and used this line but it doesnt...

Hi there, I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved? In addition, I want to startup application with a command line in a access macro and used this line but it doesnt...