Search results for query: *

What I am looking to do is to have the user select one of five different criterias as basis for one report. In other words no matter which criteria the user selects (they can only select one criteria) the report design / output would be the same for all 5 criteria's except of course the criteria...

Just a question here. Is it possible to have a workbook and take one of its sheets and save that sheet as another, seperate workbook. What I am looking at is a workbook with numerous sheets that the users can fill in, once filled we need to save that filled in sheet as its own seperate workbook...

Is it possible to have a user click a button to preview/display a report on the form itself say in a text box or ole box instead of having the entire screen changing to the report review mode then closing it out to view the form again ???

Hi, What I am wanting to do is to have a calendar control 9.0 on a bound form display the current date instead of starting with the date that is first in the database. I have seen where people have said to use the .Today after the control name but I have tried this to no avail. Any help would...

Like a student I need someone to point me in the right direction here. What I am wanting to do is to have a form randomly select an image (from a say a total of 5) and load it in a ole frame/box. Is this possible and if so what kind of coding would be needed to pull this off. I don't want anyone...

I have a bound form to a query (querying main table)that displays dates and related data. When the form is opened it displays the entire database (which is what i want) but I need it to have the current date viewed on the screen not the first date in the database from a year ago - that's a lot...

Since the search function on this site is down I could not research this question so here it is... How do I get the Calendar Control 9.0 (access 2000) to key in on the current date ? I have a bound form with the Calendar Control on it but when I open the form it starts with the first date in...

I am using Access 2000, Calendar Control 7 on a windows 2000 system. I have placed a calendar control on a bound form. Looks good, works good if you use the navigation buttons for the form. But the minute you start using the "buttons" for the dates the record information is not...

What I have is a table with the names of the days of the week. I can enter the names of the days of the week in the order that I wish (sun, mon, tues. to sat.) but when i close the table is automatically sorts itself my the order in the alphabet. How do I stop this or get around it ?? any...

what i want to do is base a form and report on a query where in the query it returns all dates for the current year that have already passed by if another criteria field (check box is set to yes). And it the opposite direction do the same type of query but for dates in the same year that have...

What I am trying to do is to have three comboboxes each respectively based on individual tables (day, month, year) and have the user select a day, select a month and select a year and concatenate(i think) the selections as a date and placed in a textbox for another tables field called date. I...

What is a good book to get up and running with SQL ? I don't want to spend a fortune on a hit and miss sql library. I just want a great set of 1-3 books, from getting started learning SQL to a code reference manual. Any suggestions. (i posted this question here as it is the most active forum...

What I need is to make a form that resembles an already designed sheet. Where as the data, being in a table going horizontally (with several rows(4)of this table seperated by space between each row). I've already designed it vertically but management wants horizontal - can this be done in access...

I am researching the possiblities (at mangement request) of having pdf files in an access database. As I have never dealt with them so I decided to put out this question to this forum. I need to take a PDF image and bring it into access so that when a user calls up the record I can display the...

What I need to have is a way to display the total number of records that a report has on it (on the report) and to format the report so that a records data doesn't get split between pages ? [bigcheeks]In advance thank you ! for your suggestions. :)

Hello guru's and interested parties. I need direction in finding a solution to something I am working on. I have a text box (txtReqNum)which uses the access standard macros of first record/last record etc... I have also a list box (lstReqNum) which displays all the ReqNum's in the database. As...

I am having to set up a security schema on my db. What I need is a guest account - which can view all but one form, a user account - which can use all but not change forms,queries or get into vb, and a admin - for me. What would be the best, and easiest way to do this ? (Sorry if this is...

I have searched and tried the examples I found here but I cannot seem to work out the trick of placing a clock on a form, that updates itself every second (I'd prefer every minute). Most examples use a lable to do this but I haven't figured that method out. Could someone spell it out for me ?

Being a little experienced access person and little in the way of a library going I have two questions for the access masters. 1) Is there a way to make a free floating tool bar? by this I mean create a tool bar (the third row from the top of the access screen) and place it anywhere you'd...

What I have is a button click event where from a form the user inputs a string (text or integer)in a text box or select an item from a combo box, after entering or selecting data in one or several of the "boxes" then fires the code below to display the results. My issue is that only...