Search results for query: *

I am using Access 2007 on a Windows XP computer. On a form open if I set me.allowadditions = false all fields disappear on form open. Set to True then all fields appear. Data source is set to me.recordsource = "select LOCALMAN.* from LOCALMAN". All fields are bound.

I have been running into some issues trying to find specific records and then saving changes. Each time I try to save the edited record the code creates a new record. Here is the coding that I am using for the form. Any suggestions on what I am doing wrong? Each field in the recordset is...

I created a form "SelectIndividualTaskList" to control what is shown on a report. The control is an unbound combobox (NamesList) that is based on a query from the table "Names1" which is joined to three other tables. I also created a hidden unbound field (SelectedIndividual) that =NamesList...

I am currently using macros to open reports for print. Most of my reports need to be printed with a Landscape format. The problem occurs when my users go to print, the reports get printed in a portrait format. Is there a way to force print Landscape regarless of how the users printer is...

I am trying to create a query from the query design menus that will return all records based on a user supplied fiscal year. I have been able to create one for the current fiscal year but not past years(i.e. 2010, 2009,etc...). My current fiscal year criteria is as follows: Between...

I have started re-writing an Access program we have. The table now has several checkboxes in it. I need to write code to look at each checkbox and filter out records that have one to several fields that are either checked yes or no depending on information required. There is also a...

I have zero experience with writing code, but what I have read in a vba book for dummies. I am trying to create a recordset then filter all records by using a user inputted year variable (myYear). I have been able to write the code neccessary to get the recordset, but that has been it. Every...