Hi Chad, There's a coupla options for this but for something a little different, set the form timer to 300, in the On Timer event type the following: Dim i As...
Hi there, I use a query to search through a table that lists my company contacts. I have the queery so I can search for a company name or a city etc. What I...
Hello, You could try this: "SELECT * FROM tbl1AllAgencies WHERE (((tbl1AllAgencies.fldAgencyName) Like '" & Me.txtCrit & "' & '*'))" Remember to replace the...
I have a table with some field. I have created a form based on those fields. Now if I cange the name of any field. It is reflected in the form but is not...
I have a problem here that I cannot debug - any help appreciated. Using MS Access 2003: I have a form with two subforms. The main form is tied (via a query) to...
Are the subforms actually embedded in the main form and linked by a key field in the parent/child field property? tombrown1965 <tom.brown@...> wrote: I...
Basically your forms and their data needs to be refreshed after add your new info. You do this by coding and event or running a macro when you click the close...
I don't have a close button on the main form and I would rather avoid having to have one. This is so I can see the main form and the embedded forms and move...
I've had problems with the Me.Refresh command also, although not an error msg. I resorted to calling a macro to do the job. Let me qualify myself by saying I...
I used the Northwind database feature of uploading photos in a database I created in 2000. I have 'locked down' the db by clicking on Tools/Startup and...
I, too, have had the same exact problem and I've tried a macro but I must be placing it wrong because it still doesn't work. I have placed it when the Main...
I have two problems I need to get solved. 1. I have to put information from two tables in a form One field from one form is searchable and it should populate...
I get an error when using this wizard to set up buttons: "Invalid use of Null" Any idea what is going on here. It will not allow me to set up buttons to open...
AC2002 using default 2000 format I have a report based on a query that sorts correctly on lastname and is grouped on the first character of the lastname. The...
I would be more proactive and use a macro with a button (SaveRecord) or action (AfterUpdate, OnChange on one of the the fields or last field that you're...
I have a report in an Access file that someone created for me. I have NO real experience in Access, it was all done for me, and now I want to do some editing. ...
Is everyone using the same version of Access with the same Service Pack level? That would be the first thing that I would check for troubleshooting your...
Hi, When my form subform loads the top of the form doesn't appear because all the fields on the "form" are locked, so no one can change data. The cusor jumps...
I believe, and could be incorrect, that older versions of Access will not show .jpg files of any sort...only .bmp files. If they have an older version than...
Who could help me modifying this code (that prints a form), so that the user can choose the printer he/she wants in a list (i suppose that as it is, the below...
Clauss Gilbert
gilbert.clauss@...
Oct 6, 2005 1:56 pm
18638
No, they are all probably using different versions but all should be 2000 and above. I have 2000/2002 and designed it with a 2000 file format. I also...
I'm a little confused about what you want, but to get a new line in a text box, you want a HARD Return, which is Shift/Return. Try that. Next, you cannot, to...
Well..... Yes, and No. On the ones who did not work. Open up the VBE and see if in the Tools, References there are any MISSING references. This can happen...
Lynn - You are correct about a regular text box, You can not add formatting to text. However, there are rich text controls which you can add which permit...
Lynn, Yup, Shift/Return, that is what I've been looking for! Thank you very much. I had tried ctrl/return, I think it was and that didn't work. Now is is...
Dawn, Thanks for the idea, but I don't think I can convince our school district to spring for the "doe-ra-me" just so I don't have to slide my bolded text box...
I need to be able to reflect total hours worked. On my form I have two fields StartDate and Enddate both fields have the full date and time. this is the code...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
