keithsimpson3973
Last Activity: May 30 '08, 03:29 PM
Joined: Aug 2 '06
Location:
-
Also, we have no support agreement for this software...... -
We are contractors for the Air Force. A company my boss used to work for used the same application nad they wrote an access script that ran when the user logged in to do what I am trying to do. We contacted them, but htey have since upgraded to a newer version (7i) and don't have the old scripts they used. Just thought someone here might have an idea of how I might go about doing it. Thanks for the help and responses anyways though! Will post back...Leave a comment:
-
Thanks. The problem is that I do not have access to the code. It is a purchased program. The script would have to run when the user logged into the application, somehow? I tried going into the Access 2000 db table where it stores the next work order number, but it appears they have something hardcoded that writes to that table if you tell the application to auto assign the next number. Not sure if this is even possible for me to do. Thanks for the...Leave a comment:
-
Access 2000 Script
I have an application (MP2) that uses an Access 2000 database. The system has a utility that the user runs at the start of each day to set the beginning work order number. We use the date + a sequential number starting with 1. I am trying to see if it is possible to write a script for Access to do this once a day the just for the first entry of each new day. I hasve looked all over the net, but not much luck at all. Any directions or links to a site... -
Access 2003 Expression
I am trying to build an expression in an access table that has a field called WO#. I want it to assign numbers automatically. The format for the number is as follows: 8- 78-0001 (where 8 is the year, 78 is the julian, 0001 is a sequential number). We need the Julian date to automatically reset each day using the PC clock and the sequential number to reset to 0001 each day as well. Any help or advice would be greatly appreciated.... -
Display Date On Access Report picked on Visual Basic 6 Form
Does anyone know if it is possible to display the value of a date picker control on a vb6 form that the user selected on an access report? I am using vb6 to display a report selection and it has a date picker combo for the start date and another for the stop date. I would like to display those 2 dates on the header of the access report I am opening from Visual Basic 6. Thanks for any help anyone can give.... -
Thanks SammyB. The person doing the project is getting ready to rework it, but isn't a real exp programmer. It was originally written by her supervisor who simply recorded macros then pasted the code into modules, then copy and pastes over and over and over, you get the point. I will pass on the info to the person in nedd, and thanks again for the tips!Leave a comment:
-
I posted the existing code sent to me.The person was getting the "Procedure to large". I could not post sll of the module here as the size limit won't allow it.Leave a comment:
-
vb for excel
Hi. I am trying build an array in vb applications for excel. I am posting the code for what I am trying to write. Any help would be appreciated greatly..
...Code:Sheets("C16-M-001").Select Range("A2:H2").Select If Range("C2").Value < (Date + 6) And Range("E2").Value < 10 Then Selection.Copy Sheets("SCHEDULE").Select Range("A8:H8").Select -
Thanks Killer42. That is a huge help. I am going to play with that for a day or 2 and see how far I can go. I just seem to be having a very difficult time understanding arrays, there process, their logic, and the mechanics of putting them into use. As always, I am in awe of your knowledge. Thanks again!Leave a comment:
-
Using arrays to simplify this code
Is there was a better way to do the following code that is currently in my project? Thanks
...Code:Dim db As ADODB.Connection Set db = New ADODB.Connection db.CursorLocation = adUseClient db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Scheduling\AAGTC_Scheduling.mdb;" Dim adoprimaryrs1 As ADODB.Recordset Set adoprimaryrs1 = New ADODB.Recordset
-
I could create one. Right now it pulls data directly from the table. It would be a lot better if I could do it in the report as the table has a lot of fields in it that the report is displaying.
Thanks for the tip, though.Leave a comment:
-
suppress records containing predetermined value
Hi, working in Access 2003. In my report, I have a field that contains a qty. If the qty is equal to zero , then I would like access not to display that record on the report. I thought you could do something like "On Print" or something like that? Is it possible to even do it?
Thank you -
Thanks Killer42. Actually, I am not sure what the best way to get the text values other than possibly the split function as the textbox could have several selections, like BDU33, BDU31, BDU34. Each is seperated by a vbcrlf and the textbox is a multiline textbox with vertical scroll bars. The listbox on the other form is populated from a table in Access 2003 and I just want to highlight (select) the items in the listbox that are in the textbox....Leave a comment:
-
Have you tried using the Shell command?Leave a comment:
-
My appologies. The code is written in Visual Basic 6..Leave a comment:
-
Listbox Selections
Does anyone know of a way to take the contents of a multiline textbox from a form, then when I open another form with a listbox on it, have the items matching the textbox items be higlighted in the listbox?
Example:
User opens form with textbox that has 2 items in it, say "BDU1" and "BDU2". He clicks on an Edit button and open a form that has a listbox that contains selections loaded from an Access table.... -
Thanks Devon. It works beautifully!Leave a comment:
-
Thanks. But selectedItems is not a valid method or property for my listbox?Leave a comment:
-
Listboxes
I am trying to select multiple items in a listbox and place the values into a textbox on another form in vb6. I just can't seem to get it right. If I select 3 items, it only returns the last item selected? Please help!
No activity results to display
Leave a comment: