Search results

This is a stand alone utility that will -relink the shared front end to the back end -copy the shared front end to the local hard drive -create a shortcut to the local front end on the desktop -create a shortcut in the start menu to the local front end Tested in x86 and x64. Not overly...

Is it okay to use the built in bitmap images? Will it cause the size of the database to increase? Or should I go through the effort of making a linked image?

What means do you provide to your end users to navigate around your database? I used to use the ribbon, but I want to stop since it is cumbersome and there is a registry key that disallows custom ribbons. I'm not sure how to do it and make it look good. My idea now is to have all forms be...

I have a custom ribbon that works fine for me, but on the client's computer it only seems to partially work. Below is a snippet of code that toggles the visibility of all groups in the ribbon. It is just a fail safe that I put in a hidden form the end user doesn't really have access to. This...

In a report, how can I reliably get the page number I am currently looking at? If I am looking at a three page report and scroll to page three, then back to any other page, Me.page returns 3. Basically, it is correct until the end user gets to the end and then backs up.

I have a rather complex where clause that is built dynamically based on optional user input. I would like to convert this from VBA to a standard query for increased speed. I've heard access does some behind the scenes stuff that make regular queries run faster than anything in VBA. I want to...

A sample that shows how to use a subform like the built the built-in split form, or at least the way I think they should be. Perhaps I've been bored lately...

I have a custom ribbon that shows or enables controls depending on what form is open. Occasionally, the wrong controls are shown and the enabled state is not correct. After a reboot, the issue is resolved. Does anyone have any idea what could cause this?

If you want to limit the characters entered into a field, you can use the control's keypress event: Private Sub Text0_KeyPress(KeyAscii As Integer) If Not ValidChr(KeyAscii, Me.Text0, 20, enumPhoneNumber) Then KeyAscii = 0 End Sub KeyAscii - the integer from the keypress event ctl - a...

Does anyone know why an unvalidated Office installation would not invalidate the ribbon? I'm working on getting Office validated, so this issue will get fixed, but I'm curious why I'm having a bunch of bugs in the ribbon only when Office is not validated. It seems like the invalidate command...

This will test all backend path locations for write access. If write access is denied or the medium is unplugged, there will be an error. It does not in any way relink tables. This is intended to be done before checking the table links, just to make sure the permissions are correct. If the...

This is a duplication of the old database window. Just import it into your project and enjoy. Use the keyboard for quick navigation and the find button to locate the selected object in the navigation pane.

This is a form that will give you quick access to database properties, and you can use it to create custom properties. The hotkey is Ctrl+Shift+P. For the ribbon option to work, you have to have the USysRibbons table.

Hello all. I wrote a module to manage datasheets more easily. It allows developers to set the columns simply by using the tag of the form and the controls. When the end users apply filters, sorts, or change the column widths, these settings are saved and loaded the next time the form is...

I have read that it should be stored in one field as a date/time, but in the front end, I have a date picker for the date, and a separate time field. Why would I not store it separately?

I am interested in making forms show current data, but I am hesitant to use requery in the timer event. Firstly, I have a huge aversion to the timer event in general. I don't like that I can sometimes tell when it runs. Sometimes the mouse wheel spins. If I am writing code and it runs my...

This shows you the basics of dynamic ribbons.

I have a shared drive at work, but I don't know the network topology. I do know there is no wireless involved. How can I determine if it is okay to use to store the backend? Can I tell simply by pinging it and checking the response time? Should I build a test that writes a new record over...

Is it okay to change event procedures with the form in form view? Up to now, I've avoided this like the plague, but if there is no code running, I don't see how it would hurt. Do we have to be in design view while writing code?

I finally did it. I think I've owned the url for over a year now, but I didn't really know what I wanted it to look like. I've also got my Access addins posted there. Since they are executable, the mods don't want them here.