Recent content by id1234

I have the report margins set right at 8.5 x 11 but I will try cutting them down a little to see if that makes any difference. I would assume that if it was a margun issue I would see the problem for anyone trying to generate this report but maybe not.

I am using the following code to create a report in a PDF file format: - DoCmd.OutputTo acOutputReport, [report.name], acFormatPDF, [filename] I have multiple people that use this function and for a couple people the right side and bottom of the PDF file is cutoff. I have verified...

I am migrating my Access Database to SQL Server. I use the following to Create a record in one table then create multiple records in a related table. When DB was in Access I set the Bookmark to the LastModified after I create the record in the first DB so I can Reference that record in the...

Unfortunatly a listbox won't work because some of the fields returned require a lookup value and as far as I can see a Listbox won't do that for individual columns.

The Recordsource for the for is derived from a search query that pulls only the records that are needed. In this case the records are Scorecard. The form may be all scorecards for a certian person. The Datasheet portion is meant to just be a list of the records retrieved and then when you...

I tried Me.frmSCDatasheet.Form.RecordSource = qdf.Name and it asked me to enter the parameters. You are right that I am setting the parameters before getting to the above line of code but the parameters are set with in the QueryDef object qdf.Name is just the name of the Query that is being...

I have a split form and I want to only allow data to be changed in the form and not on the Datasheet so I set the Split Form Datasheet property to Read Only. However, is it also possible to set the datasheet so when I select a record it selects the entire row rather then selecting the field that...

That line of code causes a Type Mismatch error. As best as I know the Recordsource property is looking for an SQL statement which can be assigned using qdf.SQL: Me.frmSCDatasheet.Form.RecordSource = qdf.SQL However, I can't use that because there are parameters in my SQL statement that are...

I am setting the Recordset. I could not find a way to just assign the recordsource because I have paramaters in the Query that need to be assigned in the QueryDef.

The below code is searching for a record based on information entered on a form using a stored query. The results are in a recordset which is then sent back to a form. I am having a problem with the code hanging when the recordset is passed back to the form (Put a *** at the begining of the...

Thank you very much for the response this was exactlly what I was looking for.

I have my Database with multiple forms and subforms, I am wanting to know if there is a way when I create my accde file if I can force only one form to be accessable to the users and the rest of the forms will only be available based on actions they select during run time. I have a Login in...

Thank you all for your Help. I think I found another way to display the data in the form without creating additional controls.

It could work to create the objects and hide them however, we are talking a potential of hundreds of controls and I would also have to create/delete controls everytime a questions are added/deleted to/from the database.

Is it possible to add controls to a form in VBA during Run Time in Access 2007? What I am trying to do is to have a label created for 3 fields (asking a questions) then a grouped set of Radio buttons for the last field. I want to be able to created them on the fly because depending on what the...