Search results

I am very new to VB and i am trying to learn more and more so that i can get better control of my databases. Hopefully someone can help me with this problem. I have a form that allows music albums and tracks to be stored along with their location etc. On the form the first control is a combo...

Hi Guys, thought i would pick your brains to try and help me figure out how to build this database. Any help would be very much appreciated as this one is making my head spin. Brief:: I need to create a database that will hold information about our suppliers and the products that they stock...

I am trying to build a query that shows me the activity of my customers. I have a database that amongst other things holds two tables which i am trying to query. tbl 1 - Customers tbl 2 - Enquiries What i eventually want to do is create a report that shows which customers have made enquiries...

I know you can create a find record command button really simply, which when clicked will display the find and replace window. What i want to do is create a command button that will search a specific field that i specify in a report for the criteria i enter. i.e i have a customer information...

In my report i have a number of enquiry entries that have been authorised. To specify whether this has happened the database has a yes/no format in the enquiries table. I have included this field in the report but in the summary of the report for each customer i want to calculate and display...

Is it possible to create a report from a table or multiple queries that show every entry and non entry in a database???? What i am trying to do is as follows.... I have a database that has a table holding all my customer information and a table holding all the information regarding their...

Does anyone know if it is possible to add a pop-up message to an individual record in a database? and if so how do you do it??? I have a database which holds infomration about suppliers, some suppliers give us fixed prices for some products to general customers but they also offer another price...

why is it that as soon as you fix one problem another one needs dealing with :mad: OK, the problem i have is that i have a BE/FE configuration database in a multiuser environment. I have built all the tables and the relationships in the BE configuration. In the FE configurations i have built...

I have a table within a database and i was wondering whether or not i should split the table into 2 seperate tables. The layout of the existing table is to record quotation information ie product codes, cost price, sell price, delivery dates available etc and it also contains fields that allow...

Hi, i am having some major problems so i thought i would ask you guys out there for some help because i am starting to bang my head against a brick wall. I have a simple database, well i have 3 but the problem is only occuring on 1. each of these databases sit in a shared folder on the company...

I am building a report at the moment from the results of a query. as part of the query i have created an expression which limits the records displayed. This is done by using the following expression BETWEEN [START DATE] AND [END DATE]. in order to run the report i have to input the start and...

Hi i have a question which i hope someone can answer. I have a database which has a switchboard as the main navigation throughout the database. (no options of toolbars are visab;le within this database). Due to this i have to keep the administration area of the database on the switchboard which...

Just wondering if someone can point me in the right direction so that i can solve my problem? Basically what i have is a select query that carries out some calculations based on data entered. These calculations are expressions as i am sure you guys know. what i want to do is put the value from...

I have created a form that displays monthly sales results. in the header of this form i want the current month to be displayed along side the report title. i know that the following can be used to identify the current month "=Month(Now())" but when i use this the month display as a number ie...

could someone please tell how i can reset an autonumber field to start from 1. basically i have created a table and carried out a number of test with useless data. now that i have the table set up the way i want it and i have tested the queries etc i want to delete all the current data in the...

Hi, i am currently designing a simple database for work and it has been a while since i have done one (about 3 years in fact) and i was wondering if it is a macro that i need to use in order to solve my problem. Basically i have about 6 update queries that i want to run by clicking a command...