Recent content by FancyPrairie

I'm retired and haven't used Access in several years, so I have forgot things. Specifically, how to format a date field on a report. I want the date Field to look like this: Tuesday July 12 So, I need to insert a cr/lf

I'm retired so it's been awhile since I used the wizards I created, so I may not have all of the info correct. But this is how I remember doing version control. To handle version control, I created a new database property and set the value of the property to the current date/time. As a...

It's been quite a few years since I messed with Access. If fileStoreID is a number, then you don't need the single quotes around it. If you haven't looked at your syntax using debug, then I suggest you try it. Modify your code to look like this: Dim strUp as string Dim fileStoreID as long...

This is FancyPrairie. Haven't been on tek-tips in quite a few years. I have been retired now for 3 1/2 years. It is really cool to see that my code is still being used. I have had people from all over the world using this code and I could never get my management to even look at it. Thank you...

It's been so long ago that I created that routine that I don't remember where I got the information. However, if you type DoCmd.RunCommand and press space while in the function it should list them all. As far as the report goes, the page is only so wide, so it will probably truncate items...

Try this: function CreateForm (strTblName as string, intFormView as integer) DoCmd.SelectObject acTable, strTblName, True Select Case intFormView Case 0: DoCmd.RunCommand acCmdNewObjectAutoForm Case 1: DoCmd.RunCommand acCmdNewObjectContinuousForm Case 2...

I've been developing an Access database with SQL as the back-end. But have run into a problem with security. Although I can encrypt the SQL back-end, how do I encrypt the data as it is transmitted across the network between the Access front-end and the SQL back-end? I need to ensure that if...

Very nice! Thank you.

Great! Thanks

MajP, I had a user create the Access database to be used by people in her department. She did an ok job, but the way she set it up requires a bunch of changes at the beginning of each fiscal year. So I'm in the process of rewriting it for her. The users have been using her database for 3 or...

Bummer! I just finished writing a function for each of the multi-value fields (about 12 of them) to do the conversion. Wasn't too bad though. Once one was done it was simply a copy and paste. However, your method would have been better and saved me time. Oh well.

On the Lookup tab on a field definition, one of the properties is defined as "allow multiple values". The "display control" property would be set to ListBox. On a form, the listbox control will display checkboxes from which the user can select multiple values. In datasheet view, the multiple...

I'm in the process of converting Access tables to SQL tables. However, several fields within one of the tables allow multiple values. How do I extract the value(s) of a multi-value field?

MajP, I've been thinking and I can do the lookups manually. You don't need to spend anymore time on it. I appreciate what you have done.

Great. Thanks