Search results for query: *

Thanks Skip, I'm not sure if I can do this, self taught. But the outer join would be between two different tables correct? This crosstab is compiled from one table. It's a table pulled out of SAP. It's an operation table so each operation represents a record. In each record is the craft, the...

I'm using code to create a crosstab table for me, this is for scheduling multiple crafts by date, tally the time and post it in a form. Problem is not all crafts are schedule each day, so any craft not scheduled will not create a field in the crosstab. What's the best way to determine if a...

Thanks to both of you, I used adalger's method and with a little massaging was able to get it to work just like I needed it to.

I have a dump from a system that I'll need to break apart into around 50 individual tables. I'll need to do this a few times a year so I wanted to automate the process. I'm down to the final part of the program and I'm having a brain poof. I want to copy a whole record out of one table and...

If I could find a method to do it without opening the file, that would be great. I started lisp many years ago but never stuck with it, most of the things I did were for proprietary machines. I know VB well enough to get most things, but I do not know the Acad libray well enough to get there...

Hi all, I've been tossed into a well fire with a water hose to put it out. Seems I've been placed in the I/E design group to clean things ups. The guy before me kept multiple copies of drawing in tons of locations and I have to straighten it out. I've use ACad since the early 90's and Access...

I'm not sure what you are trying to accomplish, but maybe I can help. Looking for a string within a string can be accomplished fairly easy with a For/Next get the string Txt do a length LN = len(Txt) For I = 1 to LN "" look for the text here""" Next I then you can look for the string by...

Thats funny, I was just talking with a friend on how I accomplished this. A quick and simple way for me was that I have a main form that cannot be closed. On that form I have a check box is visible only to my username. On the main form under the ontimer, it goes out and look for the table that...

Thanks PHV, always wondered hopw I could use that. But I still have a question. If I check if it is dirty, what would be the best way to fix it, do a save I guess?

Hello again, I have a subform in a tabular format that the users add and remove data. Also is the ability to renumber certian records. So I ran into a bit of a problem and need a quick fix (I leave for five days after today and do not want to be called at home, otherwise I would struggle...

I have a db with multiple users and multiple tables. One particular table is a bill of material. In the BOM table there is a BOM number, BOM item number and a part number. When the user needs to delete a part from the BOM, I run a simple query in code that seems to work but is at times extremely...

I use a recordest and then check to see the record count of the recordset to see if certian things exist. You could also use a findfirst.

Thank you, sometimes the simplest way is the best, I don't know why I didn't think of the on open statement. It would still be nice to know how to put this string in a variable that can be used anywhere.

I have a form that allows the users to make multiple selections and type in variables that allow them to do a search. When they click the search button, I build an sql string and use it as the recordsource of a form that opens with their results. On rare occasions the user would like to print...

Thank you all for your input. I've messed with the security groups about four years ago and it became such a headache that I have avoided using them since. For the most part in the umpteen dbs I've created I was able to control access by a simple login, but those with a little knowledge could...

I knew this was coming but I avoided it until now. I have an Access db that started very small and has grown very large. There is a small group of us entering and editing the data, so it is easy to control. Now there are about twenty more people that want access to the data, read only rights...

Roy, Thanks for the split function, and to think I've been doing it by searching a mid function for years.

Lots of ways to do this, the simplest is on open arg me.Id = Forms![Form1].Id

How are you trying to pass the data from the text box to the table, what initiates the transfer, a push button, afterupdate? Also are you actually viewing the form when you do this?

I used a couple of short loops to do what I needed. Dim dbs As Database, rst As Recordset, Brst As Recordset Dim NM As String Dim oControl As Control Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Add Parts", dbOpenDynaset) Set Brst = dbs.OpenRecordset("Add Parts Base", dbOpenDynaset) FC...