Search results for query: *

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

Very good! Appreciate you taking the time to put that together. My next step is to export the table to a SQL database. Is there a way to update the description property of each field within the SQL table with the description in the Access table?

I have 2 access tables that I want to combine into 1 new table. There are no duplicate field names that I need to worry about. I know I can create a make table query that will combine the 2 together. The problem with the make table query is that it does not copy the definition of each field...

I'm not sure if I'm doing this correctly. It's been several years since I messed with it in Access 2007. I have a situation where, from the main form, the user is allowed to open a LookUp form via an item located on the ribbon. Because the LookUp form was loaded from the ribbon, the main form...

I discovered how to make it work. On the Activate event of the form I invalidate the ribbon, doevents, and then set the active tab.

I have a main form (acts as a portal into the system), a form from which the user can edit/maintain their data, a form from which the user can select and filter reports, and a several forms that allow the user to maintain look-up tables. When I open the main form, the custom ribbon I have...