Search results

Here is an article that may help you: http://blogs.office.com/b/microsoft-access/archive/2009/02/09/automate-data-collection-forms-using-vba.aspx

If you have 10 posts you should be able to upload image to this forum.

You should create a group header and put the group header field into the group header section and then the detail fields in the detail section. This way you can shrink the field in the detail section and you won't have the gap. Not sure how your report is set up.

Well, not really unless you concatenate the fields together. But then you won't have the columns line up. There is a cangrow and canshrink property of the textbox but this only works expanding vertically, not horizontally.

If msgbox("Are you sure you want to change this record?", vbYesNo+vbdefaultbutton1+vbQuestion,"Change Record?") = vbNo then Cancel=True end if

You might want to also take a look at Outlook Redemption. I use this to avoid the security prompt when using Outlook. Plus, if you are releasing to a production environment with many users you can't always mess with the registry key. http://www.dimastr.com/redemption/home.htm

You probably need to just expand the textbox in your report design view. You need to open the report in design view and then click and drag open the textbox to make it wider.

Try adding this to the end of your code: Reports!Invoice.Focus

It sounds like you are making use of the sub-form incorrectly. If you based your subform on a query where ID = 1 then you are always only going to get that one record in your subform. It won't change. Plus if you want it to change the way you are describing, you will always only have one...

Are you using SQL Server or is this an Access table? If it's SQL use % instead of * Also, are you clearing your temporary table before inserting new records into it? Just checking. Because "WHERE CUSIP Like '0*'" should work - if it's access table. You can also try using the LEFT...

What field type is your CUSIP? What kind of data is in that field? If it's integer than all you need is CUSIP = 0. Can you post some of the data?

Well, a way to do this would be to run your report from a temporary table and use VBA. So you would have to insert all of your report records into a temporary table and then count the number of records you have. If the number of records fall short of the 20 per page than you would need to...

It sounds like you want all new main records to have the same default values that are in your current subform? Is that what you are trying to accomplish?

You would need to remove the child/parent references in the subform in order for it to keep the data in it while adding a new record - but not sure why you would want to do this?

Also, you cannot just remove the workgroup file. You would have to create a new Access 2007 accdb file and import all of the objects into it in order to have a version with no workgroup security. This can be done but you would have to create a new blank Access 2007 accdb and then open it with...

In Access 2007 if you have a .mdw file from a 2003 version you can still use it. You just need to open the database with the proper shortcut. I don't think you can invoke the workgroup administrator from Access 2007 as this menu item was removed in Access 2007 and is only available from VBA...

get rid of lines 1 through 4. don't need, plus you have an extra ampersand between Balance and From that isn't needed. 1 strSQL1 = "SELECT [CUSIP], [Account], [Registration Code], " & _ 2 "[Payable Date], [Balance] & FROM Suspense " & _ 3 "WHERE(([CUSIP] Like '0*'))ORDER BY [CUSIP]" 4...

Do you have a printer that prints double-sided? You would have to make sure you had a printer to print double-sided as well as set the report format up to work with your printer. You would probably need to add your back-page report as a sub-report to any reports you wanted that page to print...

Great! Glad you got it working.

Not sure why you are getting the ambigous name detected error. Your original pass through query has date formatted as '20130115'. So the strDate variable needs to be formatted the same way. Does your pass through query run fine from the design window with the way it is now? If you txtOrdDate...