Search results

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...

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

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.

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

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

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...

If I set the Default Field in the Table to -Date() each new field comes up nicely with a date (no time etc) which is what I want. If however I want it to be based on an event eg Clicking a tick box VBA doesn't like Date() and I have to use Now(). eg On CLick me.field = Now() Is there any...

I have many fields whose names are a1, a2, a3 etc. I want some code that will assign the field name to a variable then run the code then loop and assign the varible to the next field etc. I'm not doing it right and don't know what to do. This simple thing without the loop doesn't work either...

I have a "Continous Form" which displays data from a query. The form does not allow additions or deletes. Sometimes there is no data to display and the form comes up blank which is fine but I would like to print a message on the screen either a messagebox or an unbound texttbox saying "No...

I have a simple loop on a form that cycles through each record and sends an email to email address on each record and there particluar file. The loop works fine accept I have to hit send each time the email opens. For the loop to continue onto the next one. I've tried SendKeys ("%s"), true but...

I have quite a complicated costings forms with lots of calculations based on certain values. I then have another data entry form which requires some of the information from the calculation form. When the user enters information into the Data Entry form the afterupdate code writes the value...

Instead of using a find button can I have a text box on a form that when you type in a value it automatically takes you to the record with that value. The field I want to do this for is the Primary key therefore no duplicates. Thanks

I have a field [field3] that subtracts [field1] from [field2]. Both of the other fields are calculated in themselves. I want a label to change what it says depending on the value of [field3]. That is if [field3]<0 then label1 = "Customer Owes Us" if [field3] is >0 then label1 = "We owe...

I have to two calculated fields in text boxs on a form which add up a list of prices. One is for returns the other is for items resent. A third field subtracts [Returned amount] from [sent amount] I want an event that will make the back colour or text colour of a third field change to red if the...

I have a find button on a form created using the wizard. Is there a way that I can edit the find options in the find box so that it searches from the start of field without having to select it manually. I can change the Find/Edit under tools|options so that it defaults to this but I would have...

I have a report that prints onto labels. They are three across. This report works fine however every now and again it decides to only print a single column instead of three. 1) Any ideas how to prevent this. 2) Where are the formatting settings for the labels. So I can fix it without having to...

I have report which looks at linked tables for agent details. If however I change one of the details the report updates the changes in all previous records. How can I ensure that it only shows the values that were current at the time of data being keyed in? tia

I have about ten number fields that I want to add in a report. If there is no value in one of the fields I want that particluar field to be blank. the problem is if I put in the calculation [field1]+[field2] and field2 has no value the result is nothing but if both field have a value it will add...

How can I make a field "required" dependant on another field having a value in it. tia.