Search results

Nope but this works. listbox.additem "'chucky, chuckster'" I put single quotes inside the double quotes. Thanks M8 chuckster

I'm adding information into a list box but some fields have commas in them. The list box then decides to break the line at the comma and puts it on the next line. Can I stop it from doing this. e.g. listbox.additem "chucky, chuckster" becomes 2 entries in a listbox chucky chuckster but i...

If you want to export a report as a text file formatting will always be an issue. I think that text files are best suited exporting tables or queries in fixed width or delimited formats so they can be reused as a data sources or something. (Usually not much fun to read.) Have you tried...

yeah yeah read the help file. DoCmd.SetWarnings False

Hi There, In an afterupdate event I call some code which quickly logs the time of the change in a table. The code like: docmd.runsql "insert into..." It works fine but gives a warning about appending 1 row. Can I disable this warning as it only serves to slow down data entry. TIA Chucky

Thanks M8. I was hoping for a solution that was more scalable that looped and kept asking for the next number until a null entry was sent and used all the valid numbers as criteria. I would like to select between 5 to 200 numbers which have no real relationship to one another.(Which rules out...

Can I through Access or normal VB send an attachment that isn't a table, form, query etc? eg sendobject "c:\temp\me.txt" TIA Chucky

I would like to be able to type in multiple field numbers as criteria in a query. How would one go about doing this? I have the fields criteria linked to a form but can only print one record at a time. Thanks.

Thanks. I got impatient and wrote a function to dateadd a day then compare the day name to that of one selected from a combo box. If they don't match it adds another day etc. Thanks again for you help. Luke

Thanks M8. The function seemed to work beautifully on Friday the 19th of October. It assigned the correct date of Thursday the 25th of October. On Monday the 22nd however it now jumps to Thursday week, which is the 1st of November. Dateadd adds 10 days instead of 3. I want the very next...

I the a function or some code out there that can tell me what date the next thursday from now() is. Cheers

Maybe set an OnOpen event like this. DoCmd.GoToRecord , , acLast DoCmd.GoToRecord , , acNewRec This will automatically open to the last record then create a new record. Hope that helps. Chuck

You're right my first question was unclear. Anyway thanks M8 that's the one! Chuck [This message has been edited by chuckster (edited 09-27-2001).]

Cheers but I want it to fire before you leave the current record so that the code can quickly check whatever changes have been made. Something like the lostfocus or afterupdate event but for the current record on a form rather than a single control. Any ideas Chuck [This message has been...

You will need to either create multiple reports and have a series of if tickbox1 and tickbox2 = true then open report x etc. (Hard way and will get messy if you need to change the report) Else reference your query criteria to the form. ie in the query criteria put. iif...

I want to put some code on a form that will check the conditions whenever someone changes the focus of the current record to another one. Can I make code reactive to the navigation buttons or something. Chuck

Cheers for that. But what I was hoping to learn was an easy way to check a group of controls but check them individually. If control1 = 0 and tag = "tagrowtotal" then visible = false If control2 = 0 and tag = "tagrowtotal" then visible = false But without referencing each specific controls...

Chris RR was kind enought to introduce me to the concept of tags but I'm not clear on how to use them. **Details of what I'm trying to do.** Forms name is frmBulkOrderForm I have 10 Text Boxs named RowTot1, RowTot2 etc. They all have the same tag name "tagRowTotal". I basically want some...

Thanks Chris, I really wish now I knew that at the time. I thought there must be some grouping option like that I just didn't know what. I can think of 500 uses for that tag feature. The field names are actually coordinates of size and colours fields a1,a2,a3... b1,b2,b3 etc. ps I think...

That's It thanks heaps. Chuckster