I have a command button that runs a sql query and load the results in a form (adapted from Allen Brown). Code work great except when the query return no...

Hi, I have a subform that is using a temporary table. The temp table is deleted and repopulated via a query. The trouble is the amount of columns can vary....

-- FL

I have a form called "software info". In this form is a subform with the license number for the software. I have also created a "check out/in" form for the...

I have a form which contains milestones and I have a separate table for progress notes. I would like for the user to be able to select the milestone for...

I'd like to "personalize" logons. How can I execute a script or a series of subroutines based on a user's ID (Not the Access USERID...I have my own login...

What is the difference (other than the spelling) between the ..Update event and the Change event for a text box and/or a combo box. -- Steve S

Hi I can't figure out, how to make a form that only searches data in a tabel. I don't want any changes in the tabel. The form shall be able to look up all...

Hello! I'm trying to remove the drop down option from a subform. The subform is set to read only. Each field has been enabled and locked. Why does it...

Hi, I'm looking for a detailed book on forms and reports. Is Paul McFedries' "Microsoft Access 2003 Forms, Reports, and Queries" good? Any other...

I have an Access 2003 mdb that has several pivot charts. Everything works well. However, only the following reference will allow the code for the pivot...

Is there a way for me to have a basic Access form that the user can only fill in a form? What I am trying to do is have each employee put in their respective...

Hi, I have a small issue with subforms (see previous post 'Subform not showing correct data'). We have a manual workaround of the subform not showing the...

Hi, People, how are you? i'm having troubles with Textbox Format's, i want to put the number 33.33 but he turn the number only 33, i already tried the format...

I currently have 3 tables 1. School ----- list 52 dif schools, no puipils, cost centre number and mgnt no. 2. Meal Uptake ---- States the day,month & year...

I would like to create a button that sends an alert through email to another user. This button will be at the bottom of a form. The alert is to prompt the...

I have a subform that I use on two separate forms. There is a field on the form that shows the total costs for accessories. Here is the syntax for the...

Simple question: How do you change the title in the upper left corner of each form..?? I know how to change a message box in the module code. Like: MsgBox...

Hello all, I basically have the following code inserted in my main form (frmRunningTasks): Private Sub Form_Dirty(Cancel As...

In a form, I have the control source as a calculation. It gives me future dates for an appointment. I need the value (Dates) of that calculation to...