Search results

The record information toolbar on my copy of Access is obscured (see attached screen shot). Does anyone know if there is some sort of global setting I can adjust to fix these issues? Thanks in advance for help.

I have three combo boxes PC2, AGFND and PCA. · PC2 drop down list is independent; · AGFND drop down list depends on the user's PC2 selection and · PCA drop down list depends on the user's PC2 and AGFND I have selection queries as row sources behind AGFND and PCA. The query behind...

I'm trying to change the height of form using code and nothing I've tried works. Rather than have you read a lot of words to get an understanding of my problem, please open the attached dB and: · open the '01_EventDates_MF' form · click the 'Go To Time Period Entry' button (at the...

Hi, When I try to use the TransferSpreadsheet command, I get the following runtime error (3051): "Microsoft Access database engine cannot open or write to “XXXX”. It is already open or exclusively used by another or you need permission to view or write its data." I've used this in...

Apologies in advance for length of this post but I need to provide some background. I am the SOLE database user I designed a form structure consisting of: a subform (called 'rjMAIN_SF') embedded in a main form (called 'rjMAIN') The subform (rjMAIN_SF) allows me to enter data into a table...

I'm trying to use the following code to programmatically sort four fields on the continous subform: Me.SPlanChange_03_OFFSET.Form.OrderBy = "AOBJ ASC, ORG ASC, AVAILABLE DESC, AGFND ASC" Me.SPlanChange_03_OFFSET.Form.OrderByOn = True It appears that the code works partially - the values in...

Hello All I've have a form (dialog) with multiple text box and list box controls on it. I want to force users to enter information into each control. I set up a 'Before Update' event procedure and I used the following code: If IsNull(Me.SPCGenReason) Then MsgBox "You MUST provide a...

Hello All, I am using VBA to execute a 'Make Table' (named 'DT'). One of the fields in DT (named 'Dollars') contains numbers that have 6 to 8 digits; some are positive and some are negative. These large numbers with no commas (or parentheses when they're negative) are incredibly hard to...

I'm having a problem get a query to select all of the records it should be. When I filter the source table (200_STANDARDIZED NRGL) to show the data I want to see (PC2 = 6000; GAAP = 02; CGL = 0950, 2735, 2736, 3500 and 3501; STD VENDOR NAME = blanks), I get 33 records. NOTE: Had to take...

I'm tyring to 'Loop' through a recordset (i.e. "newRS") that has 46 records in it. I get the recordset as follows: set newRS = currentdb.openrecordset ("PO Table") newRS.movefirst I want to download each of the records, one at a time, into Excel. To do this, I'm use...

Can anybody provide VBA syntax for changing various "Field Properties" on an EXISTING table. Specifically, the field properties I'm trying to change are: Field Size (I want to make this 'Double') Format (I want this to be 'Standard') and Decimal (I want this to be '2') The Data Type is...

My office recently transitioned from Windows XP and Office 2007 to Windows 7 and Office 2010. I built a couple of new Access databases using Access 2010 and with both of them, I've experienced situations where the program abruptly stops working - I get a message boxing saying something like...

Hi. My name is Ron Pleasant and I’m having a problem with VBA that I’m hoping the community can help me with. I am trying to copy a recordset to a specific range of a specific Excel worksheet in a specific Excel workbook. This programming worked perfectly when I was using Access 2007; when...