Search results

Ok Heres one for you. have a table with a load of records of type memo. i.e 1 record looks like this _________________- This is a record I am a very nice record but i would like to have bits highlighted __________________ When I view the form, i would like to highlight any line with the...

Cheers, thats a wicked Idea.. Never thought of doing it that way round. You dont realise how much time thats saved me.

Can anyone help me :-) I'm trying to use docmd.runsql to add a string into a table. Problem is my strings contain ' (single quotes) " (double quotes) and , (comma's) This really screws up my docmd.runsql line of code. i.e TempString = "Hello' My ,Name 'Is " docmd.runsql "INSERT INTO tbl...

Is it possible to open a report like a form that is set to Popup. I have a database coded that shrinks the access window to make it look like an application and the only think that I can't get to "popup" is the reports?

Can anyone supply a line of code that will do an "Add New record" in a subform? somthing like Forms!frmScatterDataEntry!frmSUBNote.Form.docmd.gotorecord acnewrec ..... cheers CJBIRKIN I got the last one to work :-)

Sorry , can't get it to work (isnt the first bit of code and the edit the same?) i tried Forms!frmDataEntry!frmSUBNote.Forms.txtNote = "Hello" (test) where.... frmDataentry - is the main form that is open frmSUBNote - is the sub form txtNote - is a text box in the subform...

I have a form with a subform Lets call the subform - frmSUBFORM :-) in this sub form there is a text box Lets call the textbox - txtTextBox :-) Can I pass a variable to this text box somthing like frmsubform.txtTextBox.text = MyVariable Please Help me

Can I use an open database funtion to close my current database and load a new one? I'm writing a little installer. It just copys the file off a network drive to a local drive and then opens it (or rather doesn't at the moment :-))

So are you going to enlighten the world?

As the subject says. Can I embed a file into an access form (or whatever) so that I can extract it at some other point. For example could I have a button that extracts a zip file that was embedded into an access table or form or something??

I thought that would have been obvious by the lines _________________________________ All I need is a list of the names. i.e. "courier" "comic" ___________________________________ as opposed to All I need is a list of the filenames. i.e "cour1.ttf" "MSsereif.ttf"

Thanks, thats the way I tried originally. thing is, that returns the filename of the font (which is different to the FONT NAME). Unless I can figure out a way of using the filename instead. Pity I can't just use. lblALabel.FontName = "C:\WINNT\FONT\Myfont.ttf"

Is it possible to get a list of the fonts available to access using VBA. All I need is a list of the font names that access can use (C:\WINNT\FONTS i guess) I tried using the filenames with sayyyyyyy lblALABEL.FontName = C:\WINNT\FONTS\COMIC.TTF" but of course it didnt work. Any ideas?

Can i get a list of all the fonts available and store this in a combo/list box, array, anything really. All I need is a list of the names. i.e. "courier" "comic" (but obviously I need the list from the PC and not just a list of fonts :D) It would be really handy

Thanks, but that makes no difference... any other ideas? can anyone make this line below actually make the TAB appear on a label. You'd think this would be simple really wouldnt you.:D ___________________________________________ lblALABEL.CAPTION = "THIS IS MEANT TO" & vbTAB & "BE TABBED...

Why is is whenever I try to enter a tab into a text/label using VBA it always comes out wrong (i get the same with chr(13) by adding chr(10) to the end.... but if i try to create a label with tabs in it, it always screws up.. e.g. lblLabel.caption = "Hello" & vbtab & "this is a tab" should...

app.path help please Can I use app.path in access 97 I keep getting an error message such as "variable not defined" do i need to add this to my references or somthing or does Access 97 just not like this

Can you use docmd.runsql with an INSERT INTO command like this... first I open the database and a recordset. then I do some stuff, but I would like to be able to use a line like docmd.runsql "INSERT INTO [tblMsg] (User) VALUES('HELLO');" although it won't find tblmsg. (i am trying to NOT link...

I it possible to select a filename in a VB form (using launchCD or somthing) and instead of getting the filename ("N:\a\pointless\example") getting the \\server\partition\...... path instead? I'm trying to log a bunch of files in a database but get the old problem that not everyone has the...

Hi I have a list of records (all one table so nothing serious) say for example I have a list of times in a field field 1 = primary key (autonumber) field 2 = a general date field pk TimeRecordAdded 1 20/05/03 16:58:32 2 20/05/03 17:02:51 3 20/05/03 17:05:41 4...