Recent content by ewong1

This is bizarre behavior if I've ever seen it. Any input on how I can repair this issue would be appreciated. I have a database that is linked to a MYSQL database. When I open the database, I can see the data from my database and view reports. However, when another user opens the database...

This was very helpful in getting the extract to work for queries on a blank workbook, but when I attempt to extract a query into an existing work book I get the following error message when I open it: <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <recoveryLog...

Yes I am. Another technique I tried was to change the text field in my form to a Combo Box that is linked to a PK that pulls in my comments. Unfortunately, that yielded the same results.

Thanks for trying. I moved the code into the BeforeUpdate event and the system is still behaving the same?

I have a Single Form(frmSequenceTemplates) that contains a Continuous Sub-Form(frmSelect). I have a series of fields in frmSelect(one in particular called templateVersion and another called templateComment). In Sub, I have an event procedure that is called on the "After Update" command that I...

that worked beautifully! thanks!

I am querying results using Access 97(Yes its old and no my company is not willing to upgrade.....:confused:). Anyhow, I am connecting to a corporate database that has two tables I am querying that should be joined on one field (wmg.wmgtk01_tnk.sys_i = wmg.wmgwo04_halfleg_actl.tnk_sys_i). I am...

I have the code below - what I am trying to accomplish is determine whether or not there are any records in "tblEquipmentSchedule" that have a matching date and schedule type as the forms current view. I know for a fact that there are some records that exist - for example if I put in the date...

I have the code below - what I am trying to accomplish is determine whether or not there are any records in "tblEquipmentSchedule" that have a matching date and schedule type as the forms current view. I know for a fact that there are some records that exist - for example if I put in the date...

I currently have a form with the subform being a datasheet built off of a query. I am having issues with it because I want the user to be able to select a record from teh datasheet and click a button on the main form to open up an order based on the selection. Is there a reason that when the...

Got it! I was able to solve this issue by including # signs on both sides of the date variable. DoCmd.RunSQL ("Insert Into tblEquipmentSchedule(dtmSchedule) Values(#" & dtmSchedule & "#)")

I currently have a field set up on a Schedule Form(frmSchedule) that requires a user to enter in a Schedule Date (dtmSchedule). In the end, the form is supposed to check to see if there are any records in the Equipment Schedule Table (tblEquipmentSchedule) - if there are no records with that...

I have a query that returns 1000's of records and there are some simple data entry errors that I am unable to prevent because of administrative rights being restricted. When I query the tables, is there a way for me to exclude the records where "#ERROR" is showing up?

WOW I'm a programming newb... I need some help understanding a bit more. If I hard code a datasource table like mentioned in the code, how do I go about creating queries and such off of the table? Does it show up in access like a table that can be queried or do I Have to run all of my queries...

Thanks for getting back to me. I actually need to set up the connection through an oracle database on another server. Is it still possible in the manner you provided?