Recent content by data59

Thanks for the replay, but I’m not sure how this would work? How does it make the connection to the network? What I want to do is populate an unbound combo box with the list of network printers available on a given drive. This has been the toughest problem I have come across when intuitively...

I have been looking for an answer to this question for a few weeks. It seems like it should be easy but so far no luck. I would like to be able to read the content of a network folder containing available printers in to a combo or list box. The way our structure is set up we have hundreds of...

I have a ComboBox, (unbound) that has several items listed, My form is linked to a Access Database. If the combobox matches an entry in a field(ID) in my combobox, I want to be able to move to that record in my database and display the other fields information in textboxes. Easy to do in Access...

Thanks That worked perfectly

I changed my approach and tried the AddItem of the standard ComboBox, I was able to get the first item from my procedure. Now I need help with a loop to read the rest. The data from my procedure returns a string in this format Data1xxx xxx ; Data2 xxxx xxx ; Data3 xxxx xxx ;Data4xxxx xx xxx...

I have a DataCombo Box on a VB6 form that I’m trying to populate from a procedure that returns a string. It works fine in Access but I get a error “Method or data member not found” in VB6. Me.combo0.RowSource = GetData

Majp, What should I do? I'm new at this, the way I got it to start working was initializing the 2 tables with a record before I created the one to many relation ship. What I want to do is if a record in the main table is deleted, the corresponding records in the sub table will be deleted. The...

I'm getting an error due to referential integrity, the error is "you can not change record because a related record is required in table.” If I click back a record and then click forward to the current record and click enter the record takes with out producing an error. I'm confused Here...

Thanks PHV that did the trick, eyes are not what they use to be. I have a another problem however, I'm getting an error due to referential integrity of "you can not change record because a related record is required in table.” If I remove the relationship the code works correctly, accept it...

I'm having problems with this code and I'm getting the massage "Method or Database not found” I’m a newbie to VBA so any help would be great. Thanks Option Compare Database Option Explicit Private Sub Calc_Click() Dim dbs As DAO.Databases Dim rst As DAO.Recordset Dim wtb As Integer Dim r As...

Sorry if this seems like a duplacate post but I changed directions in my project and did not want to confuse the issues. so hears my my delema. Suppose I have a table that has the following fields [Job#]---[Mach Operation Type]--[Startdate(Monday of week)--[ Job duration-(Weeks)] I would...

Zion7, Sorry I have not responded until know. But thanks for your excellent suggestion on my code. Your suggestions worked great. However I’ve determined that my approach to this problem was flawed so I have decided to start fresh. I will try to simplify my question. Suppose I have a table...

Zion7, Thanks for your sugestions it got me going down the right path. The code below does what I was asking. Now I have to figuerout what to do at the end of the year when jobs will wrap into the next year. Thank for your help Option Compare Database Option Explicit Private Sub...

Thanks Zion7 I guess I wasn't clear, what I'm trying to do is have the date point to the field on my form that corresponds to the week number in the year. Example if the job required 7 weeks to build and needed to start on march 1 (wk 9 of the year). I would want 40hr in week 9, 40hr in week 10...

I have a form with text boxes that represent the 52 weeks of the year. I would like to put hourly data representing a workweek of 40 hr in the appropriate box based on a start date determined by the user. My question is it possible to change the field name based on the date selected. In my...