Search results for query: *

I have already pulled out half of it, but the rest of my hair will be gone if I don't figure out this problem soon... Background: SQL 2000 Database linked to Access 2000 front end, via ODBC linked tables. I have a form with a multi-tab control on it, and on one of these tabs is a text box...

I have a table with a bunch of addresses. Table Name: tblLOC Field Name: ADD1 (Ex: 1234 Maple Way) I also have a table with a bunch of street names. Table Name: 221Streets Field Name: STRName (Ex: Maple Way) I want to be able to select all addresses from the first table where the street...

I have a form in Access 2000 linked to a SQL2000 back end via ODBC. On this form I have a text box that is bound to a field, with a max of 250 characters, however when I type into the control, it stops at 150 characters. The field actually origially had a lenght of 150, but I moved it up to...

Pretty straight forward question... I have a list box on my form and I would like to create a button that selects all of the values in the list box. Is there a simple way to do this? TIA...

I have a table named AcctTypes with these fields defined: AcctID Name Location Phone ModUsr ModDate Any time that the data is changed in any field in this table, I would like to update the ModUsr to be the current username, and ModDate to be today's date/time. I've never created a trigger...

Let me just start off by saying I'm fairly new to SQL Server. I have a SQL2000 database that I'm developing (with an Access 2000 front end), and I'm continuously getting errors saying that "the data has been updated by another user" when working in Access and editing the data. This is still in...

I don't know why this is giving me so much trouble, seems pretty straight forward. I have two tables: tblEmployees EmpID EmpName tblArea AreaID AreaName PrimaryContactID (fk to Employees table) SecondaryContactID (fk to Employees table) I just need a simple query to show the data like this...

I have an Access 2000 database that I am developing, with a SQL server 2000 back end. Randomly, whenever I'm entering data into the table or moving from one record to the next, I recieve an error saying, "The Data has been changed. Another user edited this record and saved the changes before...

I have a list box control on a form and I am trying to set the recordsource property to a stored procedure. I am trying to avoid doing this at runtime. The stored procedure takes a single parameter @District, which is a value on the main form. How do I pass the value in my form...

I'm brand new to using Access Projects and SQL server data and need a little assistance. I'm trying to create a list box control on a main form that links to another table to show some detail (Parent/Child related data). Example Parent = District, Child = Fees. I want the list box to only...

Is it better to use the new Access Project (.adp) or the original database format (.mdb). My data is in SQL server, and I'm trying to decide which tool to use for the front end. Is anyone aware of any limitations of the new .adp format? Thanks...

I've been developing Access programs for a few years now, and in all of my forms/subforms/controls, I've always simply created a form that was bound to a recordsource like a table or query, pretty much by using the wizards and modifying the end result. I've created many complex forms with...

I have a form that displays it's data in Datasheet view. When I try to set one of the control's visible properties to false (me.txtAddress.Visible = False), it still shows the column in datasheet view. However I notice that if I remove the control completely that it doesn't show the column...

Is there an easy way to have some fields be in every new table that I create? I would like every table in my database to have the same 5 fields (GenUsr, GenDate, ModUsr, ModDate, Spare1), but I don't want to have to copy and paste them from other tables. Just trying to find out if there is an...

I've searched for an answer to this but I couldn't find the exact answer I need. Hopefully one of you geniuses can help me out... I have a field in a table that I want to be able to capture the user id and date/time that a particular field has changed. My problem is that this field is on...

I need the SQL syntax of how to update only the 25th position within a particular field. For example, I have a text field named USDATA in table named UBUCTL with data like this: " Y YY N YYY NN 000000000 YN" and I need to place an "N" in the 25th position of every record, but...

Hello masterminds... This seems like it should be pretty simple. I need to take an ADO recordset object "rsAccts" (data from AS400) and load it into a local Access table "tblAcctCodes". I know this can be accomplished by looping through the recordset and running an INSERT statement for each...

I'm gonna pull my hair out! I'm trying to group by one field, and display the first value of that group in another field, but it is not picking up the first value, even though that appears to be the first record in the table. Example DrftNo CustNo 1 005 1 006 1 120 1...

Access 2k, Windows 2k, DAO or ADO question How do you reference a field name that has spaces in a recordset? Ex: With rs duedate = !Due Date end with This returns an error, and I'm sure it's because of the spaces in the "Due Date" field name. Please help with correct syntax, thanks.

I am trying to determine the best strategy for expanding one of our applications to be used by different project sites. Currently, we have an Access 2000 application with a SQL2000 backend, which is hosted on Citrix and accessed through the internet by several remote users. However, these...