Search results

ok.. the listbox is populated from a query.. 6 fields... the primary key is called id and is the first field.. the column widths are as follows.. 0cm;2cm;2cm;2cm;2cm;2cm (so the id doesnt display but is still there) i have set the bound column of the listbox as 1 the listbox code is here...

no that is still opening the form with blank fields..

hi.. dont have much time.. haven't touched access for months.. trying to use a link criteria with a number datatype.. the form opens but the chosen record doesnt display.. here is a text datatype version that works.. Private Sub quicksearch3_DblClick(Cancel As Integer) Dim stLinkCriteria As...

it is actual text in the email not an attachment..

yes it could be that simple but then i would still have to manually copy each item and paste it into the correct cell then synchronize the csv file with the database... at the moment my customer fills out a website form the results are emailed to my outlook account then i manually enter the...

if i receive an email consisting of the following: Name: Antony Phone: 887 Country: UK can there be a way to transfer these details from outlook into an access table with 3 identical fields?

http://www.rainyjay.com/tapi/tapi.htm we have a tapi enabled phone and i want to connect it to my pc and allow it to talk freely to my database.. eg.. a customer calls up.. if their phone number exists then display their details in access.. if it doesnt exist then open a new form which lets...

lol... forget records.. i want my user to be able to scroll down the form.. imagine the form is longer then the monitor size.. to move down to the lower part of the form.. they click the scroll bar and move that downwards.. this action can also be acheived using the mousewheel when...

i have successfully managed to disable scrolling through records using the mouse wheel.:) however, im sure this has been asked many times.. oddly enough i havent found the solution.. when my user rolls the mouse wheel up and down..i want the form to scroll up or down.. how can this be done...

hi im opening my form like so.. DoCmd.OpenForm "frm3AddPerson", windowmode:=acDialog on that frm3AddPerson i use Private Sub Form_Open(Cancel As Integer) DoCmd.MoveSize 0, 0, 14000, 8000 End Sub problem is when i open the form in dialog mode.. it opens the form more to the left and top then...

control tip text does nothing.. what am i missing here?

hmm.. i might get that then..

when you do this.. http://www.londonheathrowcars.com/btn.jpg and you press the button.. the text label disappears until the button is no longer focused... is there a way to avoid this?

im not using an autonumber.. are you saying modify the invoiceref at table level to what you suggested.. i still need the first three letters of my account holder in front of that number.. could you not show me how that number could be created at form level using the code i pasted?

hello all.. i was told when trying to create this invoice number.. why not just increment? why are you using random number? the reason i wanted it random is because that is what my user wanted.. now they say they would prefer to have an incremented number.. here is what i am using now...

grrr8.. for once i ask a question that can be answered in 1 sentence

what do you put in the criteria in a date field to show records with a date = to today or less?

run time error 3061 too few parameters. expected 2

hi.. i want to set a number field (fkPaidID) to 1 this syntax is wrong.. ive looked at a few examples.. could someone explain what is wrong with this statement CurrentDb.Execute "UPDATE tblJob SET [tblJob].[fkPaidID] = 1 WHERE tblJobInvoice.fkInvoiceRef = '" & Me.txtInvoiceRef & "' AND...

thank you both.. thats pretty much everythin i needed to know..