Recent content by databasedonr

Thanks, I've inherited this and agree that the design is not great. However, thanks to theDBguy as a union query as he described worked perfectly. Thanks theDBguy - that got me over the hump!

Thanks in advance for help with this query - I'm stumped. I have a table of account numbers that has other columns, including "name" and "status". The status basically has two values - "subscriber" and "user" - basically, who is using the account and who pays for the account. Where the...

Thanks for that both answers. Yes, I've an implementation working with InfoPath, but apparently MS is dropping the product. Also, our InfoPath implementation relies on the forms being available on our network, and I was looking for something "off network" that could be readily distributed. I...

Hi all, I'm just wondering if anyone has had success using an Adobe form to collect data, and then import that data into Access? I was looking at/hoping to use XML. Essentially, I have a need to collect data "off network" and then import it into Access, and wonder if Adobe is the best place to...

I'm still around, although I have to admit I don't remember what I was trying to do 13 years ago.... I still appreciate the answer! And it may come in handy - it'll go in my code libary. Thanks again!

Brilliant! Thanks so much. With apologies for the delay in responding, but this works really well - better than I thought it might. I altered the code posted at devhut only to accept the search parameter as the value that I wanted to pass. Thanks again!

Bump. I'm surprised no one is doing this... maybe it's because it can't be done?

Well, you can remove Close button from the form in form properties and add a button of your own to close the form (Docmd.Close acForm, Me.Name) and call your save routine ahead of the close command. Alternatively you can have the Close button disabled until the user saves the record, have...

I have a database where I track department and personnel data, and from which I print a twice-yearly directory in PDF as a snapshot of both people and departments. The data is updated regularly, and the PDF is primarily used as a reference for where people were at given times, as assignments...

Thanks JHB, that's what I was thinking. I'm trying to come up with an elegant way to distribute new front-ends that are hands-off for my users.

Just a follow up to this process, as I've been trying to do the same thing, but it appears that you cannot be in the database from which you wish to create the mde (the source database). I've successfully used code similar to the above, but have not been successful if running it from the source...

It's was working fine in Access, which was one case I had - I tried the same solution in SQL Server, which did not work. I was able to solve it by flipping the values in SQL and adding them, like this: (CASE WHEN bool1 = -1 then 1 else 0 end) + (Case WHEN bool2 = -1 then 1 else 0 end) ... and...

Access vs SQL Server. This works great in Access but does not translate to SQL Server.

I have a table with seven bit fields, and I want to select the records where the total of all the bit fields is greater than 3. Is this possible? Thanks.

Thanks CJ_London, that worked a treat. I was making it far more complex, trying to sum the fields and group by etc, and was getting nowhere. This does exactly what I want very neatly. Thanks again.