Search results

Can someone please help me with what I am sure is dead simple! I know how to create a new record using dao ' Add Dummy Acceptance Criteria Dim rsAcceptanceCriteria As Recordset Set rsAcceptanceCriteria = New Recordset rsAcceptanceCriteria.Open "tblAcceptanceCriteria"...

Can someone please help me with what I am sure is dead simple! I know how to create a new record using dao ' Add Dummy Acceptance Criteria Dim rsAcceptanceCriteria As Recordset Set rsAcceptanceCriteria = New Recordset rsAcceptanceCriteria.Open "tblAcceptanceCriteria"...

"Function is not available in expressions in table level validations" I keep getting this message when trying to update the value of a text box when using the following code Forms!frmFinanceProposal!Text940 = Me.Text253 Would someone be able to explain what this message means pls!!!

I have a form called frmFinanceProposal on the form is a sub form called "frmFinanceProposalDialogue1" The main form refers to my subform as "Child845" On the subform I have a combo box that I am trying to set a filter on in the design grid of the row source I have tried nunerous options to...

I just wondered if there was a way in vb that I could make an event occur every 30 seconds, such as a requery, or refresh Thaqnks

Thanks mate, this was the cause of the prob - Office Service Pack updates solved the problem Cheers

Thanks mate, Is there anything in particular I should look for?

I Have just split my database, and placed the front end (mde) on a number of client machines in a SBS environment On starting the program, one of the machines displays the following error message "There is an invalid use of the .(dot) or ! operator, or invalid parenthese" Any suggestions...

Thanks mate, sorry that we had to go round the houses!!!

I would just like to add the record without opennind any forms please (is it known as ADO???)

Sorry, didnt explain well at all did I?!!! Sorry mate, having a crap day - here's what I want to do From a form, on the click event, I would like to create a record in another table that does not form part of the underlying query or table the table name is "tblHirerComments" What I want to...

sorry, from a form (ie a command button), then using vba Thanks

Erm, can someone tell me how to add a new record to a table pls? I cant find how to do it in the heklp section Many Thanks Andy

I am trying to send a sms measage by xml and have been given the following code......... Sub test() Dim xmlstring As String Username = "user@mailaddress.com" Password = "yourpass" Message = "Your Message Here" Destination = "447777777777" xmlstring = "<?xml version="...

Thanks Sorry, should have been a little more specific. What I am trying to achieve is converting the report to tif so I can send a fax via Outlook - apparantly it's the only format it will allow as an attachment

Just wondered if anyone knew a way of converting a report to a tif file in Visual Basic pls?

This problem has been bugging me for ages. I have a database that is running across a network (Server 2000) Each of the client machines needs to access Zetafax Server and certain printers in the pool. What I need to do is set a command that will set the default printer to Zetafax Printer...

I am trying to send data to a web form, but it wont accept it because the format is incorrect. In my Access form, I have the format & input mask settings to Short Date, which produce a date as follows 09/01/2004 However, when I execute the following code... ...main.Document.Form(0).TextBox...

In a control box on a report I have the following =[HirerCurrAddress1] & Chr(13) & Chr(10) & [HirerCurrAddress2] & Chr(13) & Chr(10) & [HirerCurrTown] & Chr(13) & Chr(10) & [HirerCurrPostcode] This is gret provided that every field has a value as I get the following on my letter 147 Main...

Ive just installed a database on a clients computer who doesnt run a server. Just wondered if anyone can recommend a piece of software that would allow me to remotely connect to his PC via the net so I can perform maintenance for him? Cheers Andy