Search results for query: *

Hi! I just bought a second processor for my MB, but I can't find any slot 1 retention clips that will work... ebay has several that will work if the motherboard has hoes for them to go in, but my MB (tyan tiger 133) has screws sticking up that the clips should screw into. Any thoughts? Thanks!

Hi! I am trying to change the RecordSource for a subform based on what the user chooses from a combo box. code looks like this: Set rst = db.OpenRecordset("SELECT LeftAssy FROM [Job Q] WHERE ( JOB = '" & Me![Combo0] & "' )") If (rst!LeftAssy = "78364")...

Hi! I am working on a database that will list off parts of assemblies that my employer makes in a factory. Sometimes, when the plans change or something is wrong with the parts list, they will issue a Temporary Deviation. That will be in another table, linked to the parts list table. So the...

Hi! I have a database with quite a few pictures, I am wanting to move them out of the database to save space. I put them in a file on the hard drive. I was using bound OLE objects to display them, but now am using picture objects. When the picture object is in zoom mode, to show the whole...

20 stars to whomever can figure this one out ;-) I have a table with assembly numbers and model codes, like this: Assy Model Code 70360-RAB-02 AST35AFG2170ADFASDF324 34850-LRQ-04 HYLWP350JLGJEO70235GAS 72389-DAE-02 SDGHHPOEWYTHWETIPOPI67...

I am having some trouble deciding the best way to update a back end table. The table will need to be updated at least once a day, but there will always be users looking at the info in the table. The problem is that, when we get the new data to update, we must download the whole table as a .txt...

Hi! This is probably something really simple, but oh well... I am trying to write a query that will compare 2 tables and tell me which records have different revision levels. The tables look like this: Table 1: assy number rev number other data Table 2: assy number job number rev number...

Hi! I need to have some tables join, but the fields won't be quite equal. The assy field in one table will be the full assy number, but in the other table it will only be part of it. For example: Table 1: Assy Num 78463-RAP-04 72400-LFW-04 78461-RAV-04 78461-RLM-04 etc... Table 2: Assy Num...

Hi! I am getting an error when I try to compact my database: Record(s) can't be read; no read permission on [insert path here] I have tried to delete all of the tables from the database, to see if I could find any problems, but no luck. Even after I have deleted every form, query, table...

Hi! I am having a slight problem with my report. I want each product family to be on it's own page, and each week to have it's own column. So it will look like this: Page 1 360 Family Week 1 | Week 2 | Week 3 data | data | data data |...

Hi! I work for a large company, and we use an oracle database to store all of the information on the stuff that we build. The problem is, none of the computers have the oracle client installed. We access oracle by using citrix, so we can only get reports and such through code that...

Just a simple question real fast: When viewing a form, is there a variable that stores how many records are in the table the form uses for data? Thanks! -Brad

Hi! I need to add a sum-collumb to a table. This is something that would be easy in excell, but I don't know about access... My table looks like this: Job date Quantity needed quantity on hand quantity availuble 5555 7/15/02 6 30 5555 7/17/02 10...

I was wondering if we could have a discussion on the advantages and disadvantages of splitting up a database into a front end/back end format. I currently have a database that only 3 users use to view information about building different parts in our factory. We are hoping to spread this...

Hi! I am running Win NT at work, and we use Citrix to log into an oracle database. I am wanting to switch to access as a front end, but I am having problems with the MS ODBC drivers. Because we use citrix, I don't have the Oracle client installed, is there any other [free?] way to get the...

Is there a way in VBA to delete a database? I am writing a script to back up a database, make a .MDE file, and then I want to delete the temporary .MDB... I could write a batch file to do this, but I would prefer to keep all the code in one file. Thanks! -Brad

Hi! I know it is a stupid question, but how do I have a subform call code in it's parent form? Is there a generic way to do it? I have been using: [Forms]![FormName].Function_Name (Value) But that isn't going to work, because more then 1 form are going to use this subform, and it has to...

Hi! I am making a module in a database that will back up several other databases, as well as compressing them, deleting old records, making .MDE files, etc. To delete the old records, should I run code from the backup module, or would it be better to have that module open the database to be...

Hi! I need some advice on how to go about running an automatic backup of my database. The steps I will need to perform are: 1. Copy Oracle-linked table to local table 2. Refresh all relationships and queries 3. Compress the database (Optional) 4. Save and make into a .MDE file 5. Backup the...

how can I run a some code on my form from a trigger on a subform? The form is named OP_10 and subform major_10, and the code on OP_10 I want to run is Form_KeyPress(KeyAscii As Integer). Thanks for the help! -Brad