Search results

Is the following possible? If so - how? I have a series of several hundred variables being assigned values. If the value assigned to the variable results in an error, I would like to assign a default value to the variable which caused the error. How do I reference the variable, or line (or...

Below is code to adjust file attributes. Public Shared Sub Main() Dim path As String = "c:\temp\MyTest.txt" ' Create the file if it exists. If File.Exists(path) = False Then File.Create(path) End If Dim attributes As FileAttributes...

I have 2 (btnX, btnY) command buttons in a form header. I have 1 (btnA) command button in a form detail. When I click btnA, it unhides a record selector and moves the buttons... Now when I click btnX and btnY, I can't click directly on the button - but need to click a quarter inch to the...

In a form - How do I layer an object on top of a listbox? :banghead:

Is there a cleaner method of holding an unknown number of strings than constantly redim'ing an array? Is it less process-intensive to latebind in a dictionary.object, rather than constantly changing an array's size?

I have a listbox on a subform (or a subform within a subform). When it is clicked I want all other listboxes to unselect. There may be listboxes on the mainform, on other subforms, on other subforms of subforms. I imagine I'm looking at a recursive function of some sort, but I'm not...

Is there a standard method of obtaining an unfamiliar object's methods and properties?

When logging time (Now, Date, etc.) - how does access handle Timezones? ie. Will 2 people entering data on opposite sides of the world at the same time have a table entry that reflects 2 different dates?

I have a calculated text box on a continuous form that doesn't paint in form view unless I click on the box. Any ideas why this might be?

Is there VBA code to select a control on a form that is currently in design view?

I would like to update a txtbox with a simple int count of the number of times a mouse is left-clicked while on an active form. How do I do this?

I'm not sure what the form_click event (on click) does. Could someone provide a quick simple example?

I have a table w/field: Number {1,2,3,4,5,6,7,8,9,10} I have a report based on the table containing: 1 field: Number, box A and box B. I would like for the report to show Box B if Number > 5, else show Box A. How do I do this?:banghead:

I want to refer to an objects properties in form: ie... set a textbox's default value = textbox.name (me.name?) How do I set this in the form's default value (...without using VBA).

I have an extremely large data entry form (think 500 - 600 various combo/text/chkbox objects). Despite personal objections, all objects must be present in a single visual end-user form. .... In terms of load speed, processing, form automations and vba -- what is the fastest and most...

What is the most effective way to open a standard save-dialog message box to allow end-user to enter path/filename? Currently using: set oDialog = Application.filedialog(2) Given the above method, I am unable to add filters for the filetype (ie. when used it will always say "*.* | All"...

After auto-repairing and restoring a corrupted database, I discovered an automatically generated access table: I've never encountered a negative errorcode before. :( Anyone familiar with the following...? table: MSysCompactError Fields : Value ErrorCode: -1017 ErrorDescription: Record is...

Is there any reason I shouldn't do the following? I have the feeling that it's a bad idea, but I can't think why... (please move if this is better suited for -> VBA?) ie. function A (param 1, param 2, param 3...) errorhandler if error due to bad param update param resume A(param 1, param...

I have a number of database that I would like to backup table data. I would like to use a single database (db1) to cycle through the others (dbA-dbZ) and export all the tables to text/spreadsheet/etc. Current process: db1 opens dbA ....OpenDatabase(dbA...) db1 imports all tables from dbA...

How do I put into a form text box?