Search results

The table containing the order details will have to have a field called Part Num that relates to the Stock Table-Part Num field. Post the details of you current Tables (i.e. fields) if you need a bit more help.

I was considering adding that to my list as well but I bought an X-Box the other day and thought it would be hipocritical of me... Oh well I guess I sold my soul to the devil a long time ago. :rolleyes:

Fair enough. Try this. Create a new Database and simply import all of the existing tables and forms etc from the original database into the new one. Not sure if it will work for you, let me know how you go.

LOL Rich... Always so verbose... :p

I've just got a bit of code that generates a random number between 1 and 10 that is then passed to a Case statement that assigns a word to a String Temp and then another random number is generated (0-999) and added onto the end of that. So you end up with something like Fish789 Or Tiger342

Hi SWK, Change OrigPlace = rs!FieldName to OrigPlace = rs (FieldName) This is assuming that FieldName is a String data type.

I dont think it's possible to link a table via IP address (Guys/Girls, please correct me if I'm wrong.). It is easy enough to link to an existing table in another Database though. Just go and create a new Table and when the Dialog box appears to create the table in Desing View, Datasheet etc...

I stand corrected. Cheers Jon, subforms have never been my forte... The more I learn the less I know...

Do you mean you wish to have a table with all you filenames and the code uses that table to copy the files? If so then try this (Access 97 only - I've heard that the below code wont work in Access 2000) : I assume that your Table with the Filenames is called [Files] and you field containing...

Oh and a chat room would be nice...:D

Just to get this straight. The second query results (for Combo2) are dependant on the current value of the first combo box (Combo1) Try putting the requery in the On_change event. I.e. Sub Combo1_Change Combo2.Requery End Sub If that doesn't work post your code here so we can get a...

I use Access 97 and thought of these... This is stuff I've come across so it's mainly subjective not factual based. Not that I'm lying to you.... Pros: Ease of use. Usefull tools/reports can be built in short spaces of time. Great depth - Can be simple or extremely complicated. Has a good...

Yes you can - but they will both have to be linked to the same RecordSource of the main form if you want them to do anything.

Try this : Sheets("Input").Select Range("F4").Select If (Selection Like "D*") or (Selection Like "d*") Then Sheets("Units").Select Range("B2").Select Selection = "DCP1" ElseIf (Selection Like "G*") or (Selection Like "g*") Then Sheets("Units").Select Range("B2").Select Selection =...

Well you could always make your changes (in regard to the variance) to the Recordset pass it to your function and then roll back the changes. MyRecordset.CancelUpdate Just a thought... P.s. The Mullet will live forever.

As far as I'm aware you can't actually copy a recordset without it referencing a table/s. A recordset is a collection of references that point to data objects matching your query. Did that make sense? It didn't to me. I think I have the skill of BS down to a fine art. Just copy the contents of...

You need to build an expression for the Combo box that adds the Business area field to a Where statement. I.e. Select DistinctRow * From Products Where [Business Area] = Forms![MyForm]!BusinessFld You'll also need to have a Requery command for the field where you choose the business area. In...

Why do you need to open up the Database? :confused: I've got a work around for this kind of set up but I mainly only use it when I lock myself out of my own applications. It may not even work on his db but I think it's poor form hacking someone else's work without their permission.

As per my instructions I have implemented the code and it works. Make sure you put in the full path file name and extension. Cheers.

How about a section for Tutorials/Sample Code submitted and maintained by the community? I see a lot of the same questions being asked and although it's great to cherry pick these to increase your posting tally (like I'm doing now ;)) it may be simpler to point a question to a tutorial just so...