Search results

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?

I am building a database that is going to have multiple users and would like to hard code my datasources into the database. The reason behind this is because the multiple datasources are required in my ODBC Datasource admin on each computer. Is there a way for me to hard code the connection to...

I am exploring some new areas (at least to myself) of Access and was hoping someone would be able to point me in the direction of some resources that could explain the role of Workspaces and how they work. Let me know if you have any questions. Thank you.

Thanks so much for your input! Both of your suggestions were effective. I ran into another problem I was hoping you might be able to help me out with as well. I was running some tests and I noticed that I am not able to run the module with two users logged into the system because it creates...

I have the following code that is causing some problems for me and I was hoping someone might be able to help. It works, sometimes, when it wants to.. and then there are other times when it processes my request once and repeats the same values over and over. What it is built to do is look into...

Is there a way to include this in Access 97?