Search results for query: *

Thanks Andy, I came up with an identical method using DAO, but I think it's time I start using ADO. Thanks for the example. Bill

CubeE101, Thanks for the ItemData tip. That will work, but it sure is easier in Access, when you can have 2 fields in a combobox, one that the user sees, and the bound hidden one that is the actual value you want to use. There's no way to refer to a recordsource and field(s) without having to...

Hi, I guess I've been using Access much more than VB lately. But now I'm trying to use a simple combo box in VB, and need some help. All I want to do is to have a combo box to show a list of names, for example. If my table has 2 fields, EmployeeID and Employee, I want to show the employees in...

lupins46, I tried your function in the query suggestion - and it worked! I now have a CONTINUOUS form that shows each person's information, with a large text box on the right side showing the groups associated with that person. I made a query that pulls the person info (address, phone, etc.)...

lupins46, Thanks for your response. I've been out all day, so couldn't reply sooner. I'll give the function suggestion a try. I just want a list of the names and groups, so being able to edit from that form is not an issue. Thanks for your help.

Hi everybody, This is probably easy, but my brain isn't working yet. I have a list of people, and they can belong to one or more groups. I wanted a form that shows each of the people and their information (address, phone, etc) in a continuous form. I thought about using a subform that lists...

dhookom, Thanks for the suggestions. I know they've tried everything such as make the text box wider, and the proper paper size. I'll suggest making sure the "can grow" is set to yes, and putting a border around it so they can actually see where that text box is cutting off - or if it's just...

Hi, Here's a problem I was told about it, and I will be looking at this Access db in the next day or two, and wanted to be prepared. Apparently there is a particular report which cuts off the printing in text boxes along the right edge. This person has changed the width of the text box, and...

Thanks PHV! That's exactly what I needed. I thought the two tables had to be linked somehow first, so I was trying to make it harder than it needed to be. Looks like the group by [Name] was the key. Thank you, and have a star.

Hello, I've been working on this for awhile, and can't figure out how to do it. I have 2 tables, and I'll simplify it by only including a few fields in each. tblIssued Name From To AA 1 20 BB 40 70 CC 100 125 DD 200 250...

I guess I'll forget about the "automatic" download part. I'll just allow the user to download the file from within the VB program. One quick question - how can you get the DateLastModified or DateLastAccessed property of a file that is available for download? (It's on my ftp site) Can this...

Hi, I've written a VB app that uses data from an Access database that is in the same folder as the EXE. Currently I instruct users to manually download an updated .mdb file periodically from my website, using a browser. (The data is updated a couple of times per week) What I'd like to know...