Search results

Trevor - i am unable to upload a copy of the database in its current form, apologies for being rude but the data within the database is sensitive as are a number of the tables created. If its not an easy fix i will have to leave it with the pop-up boxes, i was just trying to get it looknig more...

Trevor - i figured out how to see the source, it is the right query yet the issue is still ongoing. maybe i should delete it and start again?

David - Yes the form is open as the button to generate the report is after the two date text boxes have been filled in. Trevor - I must be completely behind the curve with access, how do i check the report data source because when i go to properties the option is not there?

my problem is that i've created all the tables/forms which display most of the sensitive material, to strip it would take me quite a while. Since i made the amendments though everything is running well so appreciate your help BIG TIME!!

This is what i have pasted into the criteria section of my Date Column in the query. Between [Forms]![frmFront Page]![txtStartDate] And [Forms]![frmFront Page]![txtEndDate]

David, Yes i have removed them both from there but the Parameter Value pop-ups keep appearing. Thanks Sy

David, Once i have completed her (not sure why my database is female!) i will clear out the sensitive information/tables i have created and will gladly post it.

Trevor, Thank you for the quick response. i have carried out the instructions as below but i still get a Parameter Value pop up box when i click on the report button. In the query design view i have cleared the parameters so am confused once again!!

Hi there, I'm moving steadily through the creation of my first database but have become stuck (once again!) I have created a 'Main Page' form. On this main page i have a command button which is linked to a report, which is linked to a query. When i press the button it uploads the report, not...

David, Exactly what i was looking for, thank you. i will embed within my database. thanks again for taking the time out, much appreciated.

apologies, i dont think i've explained myself well at all!! I want one drop down box with the 8 regions of the world in it. then i want a second combo box which will have just the countires within those regions. So if you clicked on 'Middle East' for example, it would bring up only the countries...

Well i plan to include a list of countires but not the cities, they can be inputted manually as all searches will be carried out at a country level. So far i have created a main table, with every field that i want in my form. I have then created a region table, which breaks the world into 8...

David, Appreciate the response, thank you. How exactly would i break the relevant data out though in each table, would i have one table for all the countries in the world or one table per region. i'm confused as to how the database will recognise which countries per region. Am i explaining...

i realised once i'd posted it that it wasnt a table related question, hence me moving it to the General section. As i said, its my first time on the site. apologies for the inconvenience, i'm just trying to get some assistance from somebody with my query. i'll carry on waiting out.

thanks for the reply, i didnt post duplicate posts, i reworded the first one to make more sense.

Hi there, I’m a very new starter with Access, this week to be precise, and i have decided to take it upon myself to start a project and this seemed like the logical place to beg for assistance so please help me somebody!!! I am trying to build an information database. The information will be...