Search results for query: *

Hi there. I've searched and can't seem to find anything regards a formula I see in Excel. Taking over some reports for a colleague that's left the company and they have formulas starting with =+ all throughout the spreadsheet and I can't seem to find/determine what the significance is...

I've reviewed the multiple posts on this but nothing applies. I once was able to export an Access Table with over 100K lines of data and it would be spanned over multiple worksheets automatically; no special coding. I haven't had to do it in a while and can't seem to find how to. I know that...

I've searched several posts and cannot find what I'm looking for. What I want to be able to do is have a list of all the share networks that a user is mapped to when a form opens based on their username. I've got the form to display the users name using ENVIRON("USERNAME"). however, I'm at a...

I'm converting some mainframe VBscript macros to VBA and can't seem to figure a piece out. In VBScript I use the EMWaitText where I look for a string anywhere on the screen to get it's X coordinate. The Y coordinate is always a constant. EMWaitText .15,strTextLoc,1,1,intRowResult...

I have code that will connect to a mainframe host, perform specific keystrokes and maneuver through screens with a given data element (strDE). What I need to do is be able to write the resulting GetScreen data into a table. I'm able to write the given data element used to maneuver through the...

Good morning. I understand the concatenate function as defined under FAQ701-4233 and am able to use it within a make table query. My question is whether or not (and if how) can a function like this be used within an SQL Pass Through query? I'm running into some performance issues (3 hours to...

Good morning. I understand the concatenate function as defined under faq701-4233 and am able to use it within a make table query. My question is whether or not (and if how) can a function like this be used within an SQL Pass Through query? I'm running into some performance issues (3 hours to...

Good evening. I've been tinkering with SQL Pass Throughs to make my ODBC reports run faster but I can't figure something out. There are several fields from the records I'm retrieving that share a key. What I'm trying to do is keep these records on 1 line of the output but can't seem to get...

I'm in the process of switching over to building pass thorough SQL queries in Access to run reports faster and wanted to know if the sequence of "where" makes a difference in the performance. For instance, if I change the sequence of the search criteria, will this possibly make the query run...

Is there a way to turn off the dialog box that asks if you want to merge changes with original document in Office XP? For instance if I send someone a Word document and then they send it back to me, when I open it, I get the dialog box. Even when I answer No & Don't Ask Again, it continues to...

Hi there! I'm trying to build a complex IF THEN ELSE expression as a query criteria. However, it keeps cutting the expression off at a certain point. Is there a character limitation when building expressions? Thanks!

Hi there. I'm having a problem keeping the changes done with AfterUpdate when the record is saved. For instance, I have a database where the records are updated on a dily, weekly, monthly basis but the changes do not hold. Example: If a certain checkbox is valued, then other fields are to be...

Hello! I have 2 fields; State and City. What I'm trying to accomplish is 1) if the state is selected from a combo box, then only the cities for that state are able to be selected (based on a table that contains state and city). and vice versa, 2) if the city is selected, then the state is...