Search results

Thanks to all of you! I will stick to one table.

Do you generally archive your records after a certain amount?

I haven't had any speed issues yet but I was preparing for future performance.

The reason I created closed and open tables was to cut down on table size to help with speed. Not sure if that helps?

Hello everyone, I've been working on trying to combine 2 queries for the last couple of weeks now and I've finally decided to give in and ask. I have 2 different tables "openCalls" and "closedCalls" . I am trying to run a query that searches both tables. I've tried Inner Join and relationships...

I will def aim for the hardwired option. We don't have the man power to deal with corruption. Thanks to everyone who chimed in, really appreciate your knowledge.

Both of you really...I am still learning about back end networks. This stuff still sounds foreign to me. Its an office of about 25 people. The building is old so there prob about 2-3 hard lines that work, then everyone else is on wifi. It is a wifi business internet service plan so there...

Thank you for that explanation. I work for a nonprofit organization and funds are scarce to say the least. We have to purchase a LAN line so I've been trying to figure out a way to share a database without placing it on the Wide World Web. Any suggestions? Thanks

Can it be used in place a LAN sort of speak. If back-end tables are published/uploaded SharePoint, will it allow a user to use the front end from their desktop while back-end runs on SharePoint?

Hello, I have a general question. I've been trying to get familiar with the process of sharing databases with additional people. Through my research I have found that its possible to publish an Access Database to SharePoint. I am still figuring it out, however, wondering if once its publish...

Wow! That's all I needed, well now I just feel silly..lol! You've been a great help as usual. Thanks again, I'll complete the thread.

Thank you! Thats perfect! What is Call MinimizeWindow?

That works perfect, but I can't get to the code

Its under Form Load on the CallLog form

Yeah, that didn't work. File attached.

The code is on my db under the form load event procedure. However, I don't have the label captions that are mentioned in the code. Which part is for the hide or show window? Do you mean upload my db?

Yes, its in the Application Window button. Its showing errors for the captions which I am trying to remove but this code is kind of confusing. I can't seem to get it right. Any help would be greatly appreciated!

Im not sure what Im doing wrong. The code in the even procedure is On Error GoTo Err_Handler If Me.cmdAppWindow.Caption = "Show Application Window" Then 'can't do this if form maximized & fills screen DoCmd.Restore Me.cmdRestore.Caption = "Maximize Form"...

I am not sure how to open the module for modDatabaseWindow?

Ok, I have a question. I can't figure out where the modDatabaseWindow is being ran from? I see an AutoKey macro but that seems to be for something else? Thanks