Search results

Hi, Just wondered if it was possible to e-mail more than 1 table using the SendObject command. Here is my current code, what I would like to do is also send the tblHirer table as an Excel spreadsheet as well! Thanks DoCmd.SendObject acTable, "tblDeal", "MicrosoftExcelBiff8(*.xls)", "", ""...

According to a programmer I know, he reckons you can run an Acces application on a PC that actually doesnt have Access installed on it by using Run Time - this would be a major help to me! Any suggestions / further info??

Sorry, I dont understand! Heeeeelpppppp!

Hi, Wondered if someone would help me with this this problem =[Address1] & " " & [Address2] & " " & [Address3] & " " & [PostCode] Is there away in which I can force a new line after each control so my address would appear: 29 Main Street Palookaville WF1 1AG ? Thanks

Sorry, didnt explain in ful!!! I would like to drive this operation in Code Thanks!

I've racked my brains to try & solve this one, but am afraid I am now stuck! I have a query (qryLog4) that I would like to export into excel, but would like the user to specify the spreadsheet name & location as to where it should be saved. Any suggestions pls? Thanks Andy

Thanks Thanks Amigo

Just wonering if there is a way I can mush 2 fileds into 1 when an event occurs, for example when I click a command button I would like the 2 fields RepForeName & RepSurname to appear in the text field Last User Ayyyyyyy Thank u!

Erm, I know this sound a bit silly....but I woudered if there was a way of adding anew record to a table using vb code? My table is called tblTransmissions The fields are TransmissionCode, AutoNumber TransmissionDate, Date/Time TransmissionTime, Date/Time TransmissionStatus / Text...

When I click a Command button, I would like to data in my ListBox to be sorted firstly by the value "ALL", then everything else in Alphabetical order. Is that possible please?? Thanks

Got it working using the ListItem Property, Only problem now is I need to set the Order of the listbox to show the value "ALL" in the first row, then sort the rest of the records by alphabetical order!!! Any suggestions? Regards Andy

erm its not working, it is set to multi select by the way

I wonder if there is any way in which I can force the value of a List Box by using an "On Click" event? for example, I have a listbox which has 5 Values in Accepted Declined Pending Paid All What I would like to do is create an event that highlights the "All" value Many Thanks, as ever

I have found some very interesting & useful code (thanx to DAVE UK) that allows me to muli select from a listbox and form a new query on its results! Here it is Dim MyDB As DAO.Database Dim qdf As DAO.QueryDef Dim i As Integer, strSQL As String Dim strWhere As String...

Its appeared now and is working !! Thanks!

PS - just looked at the program where the source code comes from & you are right, i needs this to run! Why doesn't my program show it??!!

Thanks, Cant see that option on my list - I'm running Office XP, does that make a difference?

Many Thanks! Many Thanks

I have a combo box that displays a text field, but is actually bound to a numerical value in the 2nd colomn Is there a way in which I can display the text value on a report instead of the numerical value as the report is showing a number, not the text? Hope I've explained that right!

Could somebody pls help me with this code? I am trying to create a query based on the values of a listbox, buy get the following error Compile Error "User Defined Type Not Defined" I think it's something to do with the bits in orange? Dim MyDB As DAO.Database Dim qdf As DAO.QueryDef...