HyperTerminal Control

Does anyone have any experience passing commands to the HyperTerminal window from Access code. Let me explain a bit further. I am trying to automate the process of using size data from a cutting list to operate a servo controlled length gauge at a cut off saw. The length gauge accepts simple commands (cutting sizes) typed into the HyperTerminal window of a PC. (The PC is connected to the length gauge with a serial cable.) These typed commands in the HyperTerminal window move the gauge stop to the entered sizes. i.e. the command m24<cr> moves the gauge stop to 24 inches. I produce

Sr Developer -Data Base Analyst---SFO---jobid G3034

Sr Developer -Data Base Analyst Location: SFO 3+ months 7-8 Years of Exp in Oracle SQL, PL/SQL please send your updated Resume to jobs@mapleresource.net

load xml data into Access where an xml node has > 256 columns

I have an XML download I want to load to Access. I can do this for most of the sub-nodes of the xml document. However, one node has about 400 fields. I would like to break it up and store in two Access tables. Anyone done this via VBA or a utility? If VBA, care to share the code? Bob

Keeping Form invisble until all data loaded

Apart from waiting an arbitrary period before making a Form visible is there no way in Access to know when all data has been calculated so that the Form can be rendered in one go. The Form in question is continuous with a Query Recordsource that contains several DCount fields. I've optimised the query as much as I can (saved it, indexes table fields etc.) but the Form is rendered in 'chunks' of records. I've tried all obvious tweeks including: Dim F as New myForm DoEvents myForm.Visible = True (after Visible = False in the Form's open event) to no avail Any comments/idea

Flexigrid worked in Access 2000 but not under Windows 7 and not Access 2010

I am learning that using Activex controls in Access is NOT a good idea! I need to display data from several queries in a grid with both row and column sizes determined by the query results. This worked in Access 2000 by populating a Flexigrid control on a form. Windows 7 and Access 2010 refuse to have anything to do with the flexigrid controls! What alternatives do I have, barring creating a new table and re-designing the form 'on the hoof' to accomodate its fields? Sorry if this is a really silly question but I am entirely self-taught in Access.

refresh subform doesn't work

Hi All, I have a form (A) with a subform (B). The subform gets loaded with: MyID = Forms![FrmTabelTotaal].[subFrmTabelTotaal]!ID NewQuery = "SELECT * FROM Tabel_Aanvragen WHERE [ID]=" & CInt(MyID) Forms![Tabel_Aanvragen].Form.RecordSource = NewQuery Now when I click a button on my form (A) it opens a new form where I can add a new record. When I close the form and add the record I want it to show in my subform (B) but I don't know how. Regards, Marco

Unbound control caption

Am I missing something really simple? I feel like I should be able to find this and I haven't seen anything on it yet. I have several unbound controls (2 text boxes, 3 combo boxes) for use as a search form. I want to be able to add a caption to these boxes so I didn't have to use the label. The caption would, of course, need to go away when the control has focus. There will be no calculations or anything. They are just fields used to filter the current form. If this is just not possible, then no problem, if it is, please help me understand what I am missing or if you have an idea on h

Unbound object frame

Sorry to repost. I need an unbound object fram to display varios objects including Word documents, Excel, PDFs, BMPs JPGs, DIBs, GIFs etc The word documents, Excel, PDFs, BMPs all seem fine, but I get a blank screen for the JPGs, DIBs, GIFs. If I double click on the blank screen I get an error message "The operation on the HTML Document failed" "The OLE Server may not be registered" Access 2010 Windows 7 Any ideas please

ETL/SQL expert with knowledge of Clarity tool (ID2025G) ---Phoenix

ETL/SQL expert with knowledge of Clarity tool Location Phoenix Duration: 3 Months + More details on Skill set Person should have knowledge of the SQL and should have knowledge of the data structures of Clarity and SDLC Reporting. He should be able to write the complex SQL queries and have good knowledge of MS Access and VBA to merge the data and perform the analysis as per the requirements. Start date Immediate please send your updated Resume to jobs@mapleresource.net

where to store new fonts

I'm trying to print a barcode, and it doesn't seem that Microsoft has a standard font available, that I could find so I downloaded a font, and stored it in C:\WINDOWS\Fonts but when I look at report's text control font list, the font is not in the list ? is there a different folder that access2007 looks in ?

Importing with TransferDatabase from ODBC and including Indexes

I've been trying to figure out how to make a copy of a database newly upsized to SQL Server, and asked how to do it on StackOverflow.com: http://tinyurl.com/26yhxuu => http://stackoverflow.com/questions/3612149/copy-sql-server-express-da tabase-to-another-computer I have concluded that it's probably going to be a lot easier to just import the data into an MDB file and then copy that to the USB drive for transport. It then won't require installation of SQL Server on the user's computer, for instance. I've already written code to import the ODBC tables (details not important)

Access 2007 bug with SQL Server Back End - Follow up

Back in June, I submitted this post and received a lot of help, but unfortunately, it could not be resolved as desired. http://www.developersdex.com/vb/message.asp?p=2899&r=6923328 I had mentioned that I had an open case with Microsoft. Well, today they closed the case. Here is the official response - We have confirmed this is a bug in Access. We send a WHERE clause that includes "<fieldName> = NULL" instead of "<fieldName> IS NULL". This does not return any records and Access treats this as if the record were deleted even though it does still exist. The bug will be reviewe

AutoFE Updater Slow On Windows 7 Home Network

I'm experiencing a problem where the AutoFE Updater takes up to a minute to open databases on my Windows 7 home network. Is there something wrong with my network configuration that would cause this? It is definitely the AutoFE Updater (on my network) that is causing the lag. If I open the mde file that the updater has copied to the C drive, it opens immediately with no problems.

SAP HCM Consultant----Irwin dale, CA

Job Title: SAP HCM Consultant Location: Irwin dale, CA Duration: 6-12 Months Key Responsibilities: =95 6-8yrs of overall experience in SAP HR =95 3-4yrs of hands on experience in SAP LSO -- A MUST =95 Must have completed a minimum of 2 SAP LSO full life-cycle implementations -- A MUST =95 Solid functional and technical knowledge of SAP HR Time & Payroll and OM SAP ESS/MSS project experience is a must (ECC 6) in at least 1 full cycle implementation =95 Solid knowledge of the SAP Learning Solution with

Request for code - Outlook task requests using late binding

I searched and basically found nothing (the problem is late binding). I wonder if it is possible, what variable to use and if somebody did it. TIA

Energy Saving Tips

1. Reduce heater's room temperature For each extra degree (Celsius) of temperature, your heater will consume 7 to 11% more energy. Adjust it to 18degrees which is also better for your health. 2. Install a programmable thermostat You will be able to control the heater's temperature during specific hours every day. 3. Insulate your house Loss of heat is loss of energy. 4. Fix air leaks 5. Close the chimney of the fireplace when you don't use it It is designed to drive smoke (hot air) out of the house! 6. Get an energy audit to advice you about the necessary fixes and insulation 7.

Sr Informatica Developer/Analyst in MA

Title: Sr Informatica Developer Duration: Long Term Location: MA My direct client in MA has a long-term contract position available for a Sr Informatica Developer/Analyst; 5 years of Informatica development experience is required. This person will work as a senior member of the integration team on an enterprise-wide systems implementation effort. This individual is responsible for gathering requirements, performing analysis, writing technical specs, writing/interpreting design documents, performing detailed program design, coding and testing of integration processes to support thi

Fastest Way to Export Data From Access to SQL Server

My application uses ODBC connected tables to SQL Server 2008 R2 Express as the back end, across a LAN. One function is to import data from Excel files on the local machine, perform some manipulation on the imported data and add some user input. With an Access back end, I typically would import the Excel data into a temporary local table, do the processing, then use an append query to insert it into the live back end table. With a SQL Server back end, using the same method is slow because the data is actually sent from Access to SQL Server one row at a time. I know that t

Hyperion Essbase Admin---Washington, DC

Title: Hyperion Essbase Admin Location: Washington, DC Duration: 6 months Please check the details before sending any profiles. They need really good candidates and must have excellent comm skills Job Description: Installation and configuration of Hyperion System 9 components Administration of the System, including upgrades and patches, security, and backup/recovery 24x7 support to the Hyperion System customers Proactive monitoring and maintenance of the Hyperion System and all the software/hardware associated with it Qualifications: 6-8 years hand on experience with Hyp

Popup-form difference: 2002 vs 2007

Prior to opening reports in print preview, I open a popup form with the a red detail section and a label that reads "Please wait ...". The title bar reads "Processing data". The form is set as a popup and modal set to "no". This works fine in Access 2002. In 2007 everything works except the detail section is white and the label is not visible. The title bar is still readable ("Processing data"). Any ideas why the color of the detail section and the label are no longer visible in 2007? Changing modal to "yes" makes no difference -- except to throw the report onto a tab, instead of be

best approach for a web application ?

I've got a non-profit organization looking to develop an application accessible to many people in different cities Non-profit doesn't mean pennyless, but in this economy, cost is a concern So I can create a php/asp/mysql application deployed on web server for $10-30 / month But there's a learning curve and I'm not sure the development tools are as powerful as ms-access Or I can create an access2007 application deployed on a terminal server accessible from web ? Are there other terminal server solutions other than citrix ? Or I can create an access2010 application using web

A2010 woes

For info only. A few weeks ago I encountered a problem with A2010 which I put down to Auto Updates in Windows (XP SP3). Re-installing A2010 didn't solve the problem but re-installing Windows did (thankfully, I got away without having to reformat ...) Now I have had a different problem, different client. Database works OK but closing, whether from code on button or using the red 'x' just closes the database but leaves A2010 running. Starting a different database in the same session just meant that database suffered from the same problem - Access wouldn't close. Ctrl Alt and Del

Enabled conditional

Sounds easy, I know. So I have a couple of questions about my code for a form: Private Sub SurrPeriod_GotFocus() Select Case Me.SurrPeriod.Value Case Is >= 2 Me.Year2.Enabled = True Case Is >= 3 Me.Year3.Enabled = True Me.Year2.Enabled = True Case Is >= 4 Me.Year4.Enabled = True Me.Year3.Enabled = True Me.Year2.Enabled = True Case Is >= 5 Me.Year5.Enabled = True Me.Year4.Enabled = True Me.Year3.Enabled = True Me.Year2.Enable

Unbound object frames showing blank

I have an Unbound object frames called letter The routine below runs on the OnCurrent of the form. The CheckFileExists(DocID) returns true or false if it finds the document If CheckFileExists(DocID) = False Then With Letter .SourceDoc = "" .OLETypeAllowed = acOLELinked .Enabled = True .Locked = False .Action = acOLEDelete .Action = acOLEUpdate .Action = acOLEClose .Requery End With Exit Sub End If What I want to happen is to show an empty frame if

Report Viewer in Access?

Is there a way to view a report inside a control? I want to have a form with a list of reports and view the report in another control on the same form in Access 2007. Is this possible? Thanks. Matthew Wells matthew.wells@firstbyte.net