Search results

My intended need is for an over cluttered form. I want to have, ON MY FORM, a button that I click and then displays a list of sub menus. Just as if I were to have a standard file/edit/format... menu bar INSIDE my form. Those "submenus" would open the related forms or reports for data...

Ok, I'm resurrecting this post again. After viewing Staurt Green's link above, I found that this is EXACTLY what I was looking for, but there are problems. The instructions in the link was written for Access 2002 and below. In short they stated to just create a custom menu button (which is...

thanks... what is really the difference between the 2? what can be done in one that cant be done in the other??

I have no practical application that I need help with but just a few questions on function of VB. I am obviously new to VB programming, but I have used VBA in many ways in my Access databases (although in no way an expert in VBA though). My first question is, well I figured out how to link...

I have been searching for a while now on how to convert my access DB into a standalone application. I learned that there is no magical program that will do the conversion for you, but I did stumble upon a thread in this forum where the author gave basically a tuturial on how to convert using...

thanks thats exactly what I needed. The actual use for this is as follows: In simplest explanation, I have to different order tables (unrelated to each other). I need a form based on those tables listing ALL orders from each table. So even though its a form, i guess technically it is a...

Thanks for some suggestions. I never worked with union queries, but I tried it out a little, and not quite the results I needed. I attached a DB with a silly example of what I need, but it should be understandable. I need to join table 1 and table 2 together IN A QUERY, so the results would...

I am trying to query together 2 tables and have the end result just a list of all records together in 1 list For example, lets say table 1 has 50 records and table 2 has 25 records. I need the query to display all 75 of those records. Each of those tables have different fields and are in no...

How would I know if QB exposes its library or not?

I realize that this question may be out of the scope of these forums but I'll try anyway. Is there anyway to write something, rather in VBA or something else that can be ran from within Access, that can control another software title. For a simple example... My Access database connects to my...

I am trying to create a form letter to mail merge in Word, but this isn't just your standard form letter using data from a single table/query. I am trying to create a "as best described as" an open invoices letter. Meaning I want a letter to be addressed to the customer (merging customer name...

Thanks... I originally thought of something similar to that, but im my case it wouldn't really work. Let me explain... In my db I have a main navigational form (like a switchboard but not one). This form is small in size (about 1" high and 5"wide) and contains only 5 buttons that and I position...

I played around with your suggestion and I was able to figure out how to make a custom right click menu, or add that same menu to the ribbon in the add-Ins tab, but what I was really looking for was creating a menu bar INSIDE of a particular form and not on the access window. Being able to...

In one of my forms I would like to add, if possible, a custom drop down menu bar similar to the File, Edit, View, etc... you find in any program. By drop down menu I do not mean a combo box and I also do not mean a custom ribbon or menu bar in Access itself. I am looking to create a custom one...

Thanks for the suggestions. One reason why I cant have the employees down the page and work across the top is that I am trying to create this for my boss and he currently does it all hand written on a piece of paper in the same format I am asking for, and he DOES NOT LIKE CHANGE!!! If he's...

Hello All. I’m revisiting a post I placed about a year ago about how to layout records in a certain way. What I am trying to do is create a form or report that summarizes all of my employees daily hours and tasks for each week. The actual layout is what I am having trouble with here. The...

This week a few of my back end file records became corrupt. Upon trying to open the back end file, Access did its auto recovery of the file and it seemed that it fixed everything. But something is wrong now. All my data, records, tables, etc. are present and un-modified in the back end, but I...

I think i figured it out somewhat. My problem (I think) was that when exporting my customer list (from my industry specific software) it adds for whatever reason, about 30 spaces to the end of the address. So using the like operator is looking for those extra spaces in a comparison. i used...

Thanks, but I cant quite seem to get that working. For experimental purposes and to get the syntax correct to yeld the results I should have, I'm basically for now just trying to get a matching records from the original master address list and the original customer list using the like operator...

Thanks. To try to filter out and remove those last 100 or so records, I'm going to try and experiment with using the like operator. It would be too confusing to try to explain exactly what I'm trying to do so instead here a more simple example, but same concept: First of all, can I use the...