Search results

The \\ may be misleading--I shorted the link for brevity and confidentiality's sake, but the link does go all the way back to the server. It has to start with \\, right? I did locate a global.asa file (which I had never seen before). The database I want to add doesn't seem to appear in it...

I really hope there is some way to handle this. If there is any more information I can provide, just let me know.

I have an .asp page that had the following query: SQL="SELECT * FROM WorkOrder WHERE WorkOrder_Number='" &strWorkOrder_Number&"'" and that worked fine. However, I wanted to also link to a different database on a different server. So I used Linked Table Manager in Access to create a link...

Thanks, I didn't know you could add a table twice!

I am trying to link two databases that were developed independently. A simplified example: one has an ASSEMBLY table like this: AssemblyID WidgetA-ID WidgetB-ID and another has a WIDGET table like this: WidgetID WidgetType I'd like a query that would report this: Assembly ID, WidgetA-ID...

Thanks for the assistance, all. The query that the form is based on was fairly different from the query the combo box was based on. The lvr number was correct, but the form couldn't get to the record, because it was being excluded from the query.

I have a combo box that has this as its row source (it's just a select statement that brings up the options we want, I don't think it needs to be scrutinized): SELECT tblTestStationEquipmentList.elTEptr, tblTestStationEquipmentList.PartNumber, tblTestStationEquipmentList.Item...

Thanks very much for your help. I'll try and get this working today.

Yep, I agree the tables aren't structured properly, but this database has been around for years and switching everything up would not be an easy task. I'm not against some quick and dirty programming for the time being :) I understand your logic, but I'm not sure I get this part: Is "mySQL"...

Hi there, I want to create records in tblPartRevisionHistory (a more accurate name would be SerialRevisionHistory) for serial numbers that *do* exist...in the parts table. There can be many serial numbers associated with a part/revision. For example, the parts table might look like this...

Hello, I have a database form that currently adds a new revision into a table for a unique part number and serial number combination, like this: Private Sub cmd_Click() Dim rec as Recordset Set rec = CurrentDb.OpenRecordset("tblPartRevisionHistory", dbOpenDynaset)...

I am connecting to an Oracle back end. I am 99% sure that I am using the same driver (Oracle ODBC driver) as everyone else, but I'll double-check. Thanks

I have a table linked through ODBC. Each record has a primary key ID; my ODBC refresh interval is set at one second. Whether in the table itself, or in a form linked to that table...every time I update a record and then move to a different record, every field in the record I just updated turns...

Hi everyone, Thanks so much for your prompt responses. I had a personal issue come up and was unable to get back to this. I'm going to try your suggestions tonight; I'll keep you all posted :) Thanks again.

I inherited a database that was working fine, except one field was showing LocationID instead of the Location text. So, I added the already-existing Location lookup table to the query, saved, changed the field on the form, switched to Form Mode and took a look, everything looked fine. The...

Thank you SO much, Brian. I'm about to go over the code and make sure I understand what it's doing. I've never done anything remotely like this before. My example was a simplified version of the much larger spreadsheet I'm working with, but I'm pretty certain the same type of logic will be...

I'd sure be grateful. I not only have absolutely no idea how to do this, but absolutely no idea where to find an example of anything like it!

I have a lot of data in the format shown in Sheet 1, and I can't figure out how to set up a macro that would put it in a format like Sheet 2. My issues are: - I don't want to include any blank rows when moving the Sheet1 data. - The totals on Sheet1, which come every set number of rows...

If I have a table with records like so (first number is ID) 1 A 1 2 B 3 3 C 7 4 A 2 5 B 9 6 C 2 7 A 1 8 B 8 9 C 4 Is there a way I can turn it into something like this (whether temporary and/or permanent) for better analysis? 1 A 1 2 1 2 B 3 9 8 3 C 7 2 4 Thanks in advance!

Thanks for your help!