Search results

Hello. I want to work with the value that a cell address located in a cell corresponds to; and I want to use it in a calculation (=sum(x+y)). Is there a way to convert the cell (say D3) to its value (say 50) and add it to get an aggregate number? Any help is appreciated. Thanks.

Hello! I am wanting to set-up a macro or code an "if statement" in MS Excel 365 that will allow me to find whether a company has previously made a request, if so to identify today's current aggregate total and add the new entry's total to it to arrive at a new aggregate total. Can someone...

Hello. I am using MS Access 365 using VBA. However, I continuously get the above cursor error message shortly after opening the customized software. Has anyone else come across this issue? Any help is appreciated. Thank you.

I get a 'No Current Record' MS Access error message on the first line of code below: If rst("PROFESSIONAL_REG_NUMBER") > 0 Then Set db1 = CurrentDb() strSQL1 = "SELECT * FROM Table2 WHERE Professional_REG_Number = " & rst("PROFESSIONAL_REG_NUMBER") 'Set db1 = CurrentDb() Set...

The above error message is returned when the following code is executed: If rst(PROFESSIONAL_REG_NUMBER) > 0 Then The table does list this field as number and the label from the form uses text. Is there a way to convert this field without changing the form? I am not certain the number of...

The code below is placed in a button control in ms access 2007 (using vba), however the above error message is returned at the set rst = db.openrecordset(strSQL, OpenSynaset) line. I am struggling with this for some time, but no solution yet. Any help is appreciated. Thanks. Dim db As...

Currently using VBA for Ms Access 2007. The current issue I want help with is the basic syntax, objects and/or methods required to do the following: Read a specific table (say table1) from project where form num equals num found in table1 Then If the reg_number field from table1 = reg_number...

In MS Access 2007 (VBA) a select query statement is utilized to create a temporary table with the same data. I want to access the temporary table to verify an id field, but it appears that the data is missing and the system does not recognize the variable. I double checked that the name is...

There is an existing application which allows new records to be created from a button off the main form. When using this button to add new records the above-noted error is returned. This error is returned when the system attempts to execute the following code: intCoNo =...

An existing application no longer allows data entry in new record. Typing yields no affect. Has anyone encountered this issue before? Any help is appreciated. Thanks.

MS Access 2003 (Windows XP) application recently migrated to MS Access 2007 on Windows 7 platform. Now reports page header height is set to 22" and cannot be modified. This is the case for all included reports. Is there a fix for this yet? ~Phyllis

There is a requirement to display the results (Tope 3 Dates to flow side-by-side) for a single column query in MS Access. The application was written in 2003, but has been converted to 2007. Any help is appreciated. Thanks. psimpson

There is a need to produce a report from several tables. The report generates fine, but some listings are printed 2 or more times giving different telephone numbers only. It appears, as in one case that the business telephone and business fax numbers are printing. When I look at the telephone...

A specific dataview has been set-up on a partner server for company to access. Can someone provide specific directions on how to retrieve the data? The database is looking for the data on my home drive, not the server to which I am connecting. I import the data into a blank database and write...

Is there a way to comment out a specific section of a SQL query within MS Access? The normal SQL commands such as, rem text; ' text ; - text ; or /* text doesn't seem to work. Any help is appreciated. Thanks.

I want to use an existing public encapsulation and set a value. However, the default.aspx.vb will accept the input value, but not assign it to the new encapsulation. Does anyone have any idea as to the possible problem(s)?

Currently there is a MS Word application that runs a MS Access query to generate data for the Mail Merge with a document. Does anyone have a suggestion as to how this process can be optimized? Specifically, looking to reduce the amount of time required to produce letters (best practices)...

We recently experienced network issues here at work. Now I need to make sure the current version of the MS Access application is running. Is there a version compare component with MS Access? Does anyone have a recommendation on software that will work well with MS Access 2003? Help? Thanks.

While attempting to create an MDE file, the system hangs-up. User must exit system using "End Task" option, because system isn't responding. This continues after performing "compact and repair." This feature works fine with tables only in the container. Does anyone have any suggestions? Help!

While working within MS Access--and using debug tool--I received the following error when selecting the find button on a specific form: Command or action 'Find' not available at this time This is an existing application and works fine normally.