Search results

I have a DB with 4 related tables. The 2 tables in question are bookings and services. The bookings table includes booking #, customer numbers, date booked and quantity. The services table describes the services. What I would like to do is query the 2 tables to see which service has not been...

Thanks I'll try that. Freddie

Thanks I will try using the queries, the reason for 2 tables is that each is require because of different information in each field for the 2 different years. We use the database to view results in the related fields. The database in almost entirely memo fields with notes of class results. If I...

Thanks Database works fine. I would like to display information on the form that utilizes 2 different tables, related, each with the same fields, each table is almost identical but the fields are lableled last year in 1 and this year in the other. Each table key is the id used to related to...

I need a form that has multiple categories, 7, listed one after another vertically. I also need the categories divided in to 2 columns. I need to have 2 combo boxes, 1 each controlling the info for each column. Can I do this on 1 form. Suggestions would be appreciated. Freddie

I am learning VBA to enhance my databases for my customers. I would like to be able to backup the database from a button on the switchboard. Any suggestions on how to get started would be appreaciated. Freddie

Reports for text (memo field) Make sure when you use the memo field, on your reports, you set the properties to can grow. This way the memo field when displayed will show all text. Freddie new guy Hey from Ohio

The goal is hiding the menu bar. I have accomplished that by inserting the commands listed here by several people, I appreciated that. I have inserted the command to hide the menu bar in the splash screen code. The problem is that when I open the DB without holding the left shift key down the...

Thanks again Thanks for your continued help. Freddie

Thanks I'll give it a try. Thanks, Freddie

I have a database that keeps track of PDF files. The links to these files is stored in a hyperlink field. As new PDF files come out, usually in email, we save them to the PDF folder. In the form, add new record, we can right click and choose to add a hyperlink to the PDF. My question is how can...

Trouble hiding menu bar/viewing shortcut menus First , I am pretty new to VBA code and such. I am trying to hide the menu bar when the DB is opened. When the db is opened it goes right to the switchboard form where I have added the additional form buttons. I read a post here that, (ghudson)...

I am running a parameter query at the report level. The report runs fine but I cannot get the report to maximize on opening. I have put the maximize command in the code for the button. It will not maximize. Maybe I am putting it in the wrong place. Any help would be appreciated. Freddie

I have tried to maximize a parameter query run from the switchboard. The report runs fine but I would like to open it maximized. I have tried putting the maximize command in the activate section of the report and it still does not work. Any help would be appreciated. Thanks, Freddie

Thank you Thank you, Freddie

This is probably a silly question, but for me just starting out it needs clarification. What is the difference between executing with a macro and executing with VBA code. I am just starting to get into behind the scenes stuff and I am confused about this. Thanks, Freddie

1. I have been able to hide all menu's on startup with the exception of the menu bar. Any suggestions? 2. I would like to maximize the size of the forms when they start after clicked from the switchboard. Any suggestions? 3. I have inserted a close button on the switchboard (used option in...

Menu bar Hiding menu bar requires code inserted into the form event when it is loaded. I understand that, but just where do I do it. I have the command from a previous post but I am still having problems as well. Thanks, Freddie

Just a little confused yet Where do I put the conditions? In the code, in the form design, or in the data design view? Thanks, Freddie

Button to Apply fitler that I added Command button placed on form is active with other command buttons, (filter by form), the instant that I click the filter by form button the other buttons gray out. I just noticed that if I position the mouse over the apply filter button and right click it...