Recent content by Shortie

Create a procedure that filters the cboSupplierName... Sub FilterSupplierNames() cboSupplierName.recordsource=""; if not isnull(cboCustomer) then cboSupplierName.recordsource="Select SupplierName From Suppliers where Customer = '" & cboCustomer & "';&quot...

I have use a tool called Ghostscript to convert a document to PDF. I setup a printer that outputs a postscript file to say c:\temp and then code a command to call the ghostscript. This reads the postscript file and converts it to PDF. Cheapest way I know. It works well. The only drawback is...

Tools / Startup / Display Database Window Untick To redisplay DB Windows press F11 On On Johnathan Perry

If the time field is a combobox, set the column count to 2 and bound column to 1. Set the source to pull the time and dayofweek. Set the widths to 1cm;0cm (thus hiding the 2nd column). Afterupdate of time combo, pass the dayofweek field the value from column 2 of the time combo. ... 'Column...

Have an "View PO" button on the form....and lets say you PO Number field on this form is called "PONumber". Now understand that my syntax may not be correct and that you will need to include the Reference (Tools/References) for your version of Word. However, as a starting...

Would this be something you would run daily? (i.e Click a button to notify all relevant parties that a contract is up for renewal) You could have a temporary table that listed all the contract numbers up for renewal. At the beginning of each day, the table is updated (semi-automatically)...

It all depends on what format you want the text to be in. If you just want to be able to enter text into a field, and then output that text to a file, then use VBA's Open command. What are you trying to do?

In you SQL String replace the code TempCount & rst.Fields("ID") with iif(rst.Fields("ID")=1,TempCount1,iif(rst.Fields("ID")=2,TempCount2,iif(rst.Fields("ID")=3,TempCount3,0))) Basically, If ID is 1,2, or 3 the relvant TempCount varaible is used...

You could try transposing the data from SAS 0=A 1=B 2=C 3=D ... 9=J A=01 B=02 C=03 .... Z=06 SAS ACCESS "146AAD00000" = "BEG010104AAAAA" "1460AD12345" = "BEGA0104BCDEF" "1461AD12345" = "BEGB0104BCDEF&quot...

You will need to save/export your Form as HTML, follow instructions to save as ASP. Have link on web form to open the asp file (as opposed to the mdb file)

It's me again On selection of item on subform run this code Dim varItemToLocateOnBaseForm varItemToLocateOnBaseForm = FieldOnSubForm Form![BaseForm]![FieldToFind].SetFocus DoCmd.FindRecord varItemToLocateOnBaseForm, , , , , acCurrent, True

Sorry about that. Don't stress - try this - It works for me. Private Sub cmdCopyPost_Click() DoCmd.RunSQL ("INSERT INTO tblPosts ([Kategory]" _ & ", [Company], [Adres], [Zip], [Contact], [Phone], [Cell], [Fax], [E-Mail], [Contact2], [Date], [Info]) " _...

Try using a Form with a list box. On opening the form, populate the List Box with data from the table. 1. Creat a form with source to point to your Table. 2. Put a text box on the form (Call it txtServers) that has control source of =Count(Field1). 3. Put a list box on the form (Call it...

For Access 97 check the following Reg Keys:- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Report HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Clipboard Formats Post the code up you are using, let's take a look.

Shell "C:\Program Files\Microsoft Office\Office\Winword.exe -p " _ & inputbox("Please enter the full location and name " _ & "of the Word Document you wish to print." & vbcrlf & vblf _ & "e.g. Drive:\Path\Filename", _ "Print Word...