I have a database application I'm developing that is used to track RMA data for my employer. From the main RMA form I have added a button allowing a search of...
I am trying to improve on a database that I've taken over and there are queries with several if statements. The result of the if statement is intended to...
I am NEW to Access - have no clue where to even start. I have been lurking for awhile and it seems that questions are being posted but no answers. Are the...
I recommend joining MSAccessProfessionals at yahoo, if you want a more active group. Not that this one isn't active, but msAccessPros has a lot more...
I would base you sub report on a different query and then tie the two report together based on a unique id such as RepID. this way your main report reflects...
my program runs in a mixed envrionment Windows XP and Windows 2000. I have a toolbard with the CALC command on it. However, some users windows directory is...
I've created a bunch of forms with their own navigation buttons (people were complaining the standard set was too small.) So I made them a nice 0.25" each...
John What I think is to have a public function for each button on the form, which can be called when the button is clicked. For example, in the onclick event...
Hi all, I am trying to create a query (to create a report) to summarize the VAT paid by the company per quarter. I did this for the sales database, I thought...
Susan I'm not sure of the structure of your database. However, if the table contains VAT code, amount paid and date you can simply use the report to group the...
Hi Liveson, Thanks for the hint. I had already tried that, but with no joy. However, I did get the query to work ... It was something soooooo simple... like...
Glad you have sorted it out. Sometimes it's really those simple things that make developers spend sleepless nights!!! Goodnight - well it's 7:45pm here! ...
It is often the case that by taking the time to write out what the problem is, you perform a mental step-by-step double-check of your processes.. and that...
First, let me introduce myself. I am Jim, I am a programmer by trade (mainframe, dabble in a little VB.NET). I am currently working on a MS Access database...
Jim If I understand your problem at all, in the underlying query make sure you drag the required fields from the two related tables on PositionID. I suppose...
Dear All, I need the groups help urgently. I am stuck and cannot find a way. Please help. I have a text box in a form that is bound to a query field. This...
Why not restrict the number of characters in your query? Like this: ConcatenateField:left(OtherField1 + OtherField2 + OtherField3),30) John -- John V. Ruff –...
I run a small internet retail store. Thus far I have been keeping my records (orders, inventory, invoices) in separate Excel spreadsheets. I want to start...
Rhonda I assume you are a bit familiar with relational database management system which MS Access is all about. From your description I feel you should have ...
Hi Liveson Don't assume anything. I am familiar with the concept of databases but I have not used Access before other than to play around with the templates -...
Rhonda The order in which the tables are created does not really matter. You can start with any table. - Create a new database - In the database window and on...
Liveson, Thank you for all the help. I have been working on this and seem to be making some progress. I have set up two tables (customers and inventory). ...
Ok, I have these tables created. I tried to do what you said as far as creating the primary and foreign keys and relationships. I'm not confident it's set up...
Rhonda Sorry that I've just seen your message now. As I'm writing it's 7:35am beginning of a new day. Well, do you mind listing down the fields of each table?...
Ok, let's see... my business is on the internet so every order comes to me via an email that has the following information: Order Number Date Billing name,...
It will help. Just send it over and I'll have a look. It appears we have a very big time difference. Here we are at GMT + 2 hours. I'll be knocking off in...
What is wrong with this code...trying to set up a selection Combo Box for a form. I keep getting an error stating it is missing an operator? Thanks! Private...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
