Recent content by ant1983za

Hi, How do i rewrite the following code to generate the pdf as a higher res document. I know how to do it manually; you save as pdg but then select "Optimize for Standard (publishing online and printing) as oppose to the default Minimize size? So in short; how do i stipulate in the code to...

Apologies for not being clear. I meant: Is there a way that i can select multiple records in the list box and when i click ok to go to the search results page all of what i selected is displayed in that form.

Hi, I have a form called frmNotInvoicedSearch and on that form i have an list box called listCompanyClient populated with our client's names. I then have a command button called cmdOK that brings up a search results form called frmNotInvoicedSearchResults. Currently i can select one of the...

I have two tables in a query joined by a ID field. The problem is in the one table the ID fiels is a text format and in the other table its a number format so the query builder doesnt like that and gives me the Type mismatch in expression error. Theres no way around it though; i need it to be...

Hi, I have a form called frmBillingExport. On that form i have a button called cmdExcel that when clicked exports all the records to excel. On the form i have a sub-form called subfrmBillingExport and in that form there are lots of fields and one of them is a tick box called blnInvoiced. The...

Hi All, I found the below code a very long time ago (years i think) and implemented it and it works perfectly. I recently had to add a password to my back end and so now this is causing problems with this code. Is there a way i can hardcode that password somewhere in the below. Where? I'm a...

Hi, I have a log in screen called frmLogIn and on there i have Unbound Combo Box cboUser and Unbound Text Box txtPWord. I also have cmdOK. IF the user sucesfully enters his password it takes him to frmMainMenu. On that form i have a lable called lblYouAreCurrentlyLoggedInAs and a unbound...

Fair Enough. After clicking around this is what i think i want to do though its telling me 'Object Required': Private Sub Form_Load() Dim rst As Object Set rst = BlahBlah Do While Not rst.EOF ******CODE GOES HERE****** rs.MoveNext Loop End Sub

Hi, So I have copied a piece of code from someone and want to adapt it for what i want to do but I'm stuck. (I'm a newbie so to you guyz this is probably relatively simple) This is the code: For i = 1 To 9 If IsNull(Me("txtStreetNumber" & i)) Then Exit For End If And...

I cant view the links in your signatures. Dang.

Hi, So I am relatively new to VBA etc so please be gentle... I am trying to automate the generation of a reference number incrementally by 1. In my main table (tblBooking) I have my primary key field autBookingID which is an autonumber. In another table (tblBookingStops) I have the...

Hi, My db is split into a BE and FE. BE on the server and a copy of the FE is on each user's PC. Whenever i make a change i have to copy the FE to each user's PC and this is a drag. Is there a way to do it automatically? Thanks.

Thanks that worked :)

Hi, I am a newbie and need help with setting the date format of the below dateBookingTime field. It currently desplays as 07:30:00 PM but i want it to display as 19:30: Private Sub Form_Load() 'Chauffer Drive If numTransferType = 1 Then txtMessageOutput = "Dear " & Title & " "...