Recent content by sierra467

I believe you can also use a REDIM statement.

Hello, I am trying to figure out how to click on a button in an Access Form to create an Excel spreadsheet with certain rows and columns hidden. This specific example is supposed to create an Excel workbook with a single sheet named "TheOnlyWorksheet" containing only the autofited "A1" Cell...

Thanks. I know about twips (1/1440 of an inch) and locating controls on forms, but I will do a search on that to see if anything more comes up that might help my real question. Again, I am not so worried about the distance, more about how to reference a form's locations that is open, so that I...

That was great, thanks! A follow up question - How could I use MoveSize() to place a form in reference to another? For example, If I want Form2 to be opened 1" below and 3" to the right of Form1? Thanks again!

Another thought I do not have too much experience, but if you use a DoCmd to open your form and use the OpenArgs argument to pass the name you want to use in the new form's Load event, it might be an other way to go. Sending Form's DoCmd DoCmd.OpenForm "FormName", , , , , ...

I have multiple forms that I need open at the same time and I would like them to open in a specific location in relation to one another, rather than centered on the screen. I can not seem to find a Top or Left property in the Form properties to set. Is there a way to position a form on the...

GolferGuy, Thank you so much for your "above and beyond the call" help! I can not believe that I am the only one who might like to do a report like this, I am surprised it is so difficult. I really appreciate all your help. I am stumped right now too, I hope someone else can lend a hand...

I arbitrarily chose 20 as a fixed number of attendents to try out the suggestion and entered the following in the OnFormat Event of the dtmAttendHeader: srptRoster.Report.Height = (20 / 3) * 0.25 * 1440 However, all I keep getting is a run-time error (2135) stating - "This property is...

Thanks GolferGuy - I am glad you like the look of the report! I liked it too and wanted it to come out the way I described but had no idea where to place code or how to approach this one. I will give you suggestion a try and let you know how it turns out. You have been a huge help on getting...

I am trying to make a multiple column report that reports the names of people present on a each day over the duration of a conference. The purpose for doing this is to save paper. I want the report to have 3 columns per date section and I would like to have it display the names in the format...

My Solution Hi there, I think that the cause of the issue I was facing is explained in this article http://support.microsoft.com/kb/308630 . The table MSysCompactError seems to be created by MS Access just as a display to show you what it found wrong due to the Compact and repair database. I...

I have a db that was created in Access 2003. It has been split into a front-end and a back-end. It has been written to (~1200 rec) and all of a sudden last Friday strange things began to happen - Database took up to 6min. to open, certain reports stopped working (I kept getting Runt-Time error...

The reason I am doing this is because someone asked for it and it seamed easy enough at the time until I got into it. Right now the cbobox is part of a form and it populated from a table that contains dates entered into the table by a person that overlooks the db - yea, I know, not the correct...

If I understand you correctly, in Control1's "On Exit" or "Lost Focus" Event place the code: IF ISNULL(me.Control1.value) Then MsgBox "Error, This control can not be null",vbExclamation, "Error" me.Control1.SetFocus End If

I have a combobox, cboStartDate, that when clicked on opens a Calendar Control 11.0 directly below the combobox. When a date is selected, the Calendar object is hidden and the date is placed in cboStartDate. It works great. The problem is that if no date is chosen (user selects cboStartDate...