Search results

I am using Access 2000 for my database, and I am wanting to know if there is a way I can create a button on my form for someone to click, that will open a browse for file window and let them choose an image to save to that file in the database. All images are in BMP format. Any and all help...

Disreguard this post, I posted it in the wrong forum, and have since reported in the Forms forum.

I am making a report from a query, and my DB contains a date. What I need on my report is that date PLUS the number of days from that date until the date of the report. Sort of like: Todays Date - Entrance Date = Number of days I need. Anyone help me with this info?

Never used CR, and figured I'd check here to see what the best how to books are before I waste my money.

Below is a description of a report, and what I need to do to it. I know I can use conditional formatting to do it, I just dont know how to code it. Report: Each row consists of a member and lists the following info... Name Address Phone Superclub Member(Y/N) VIP(Y/N) Now, what...

I use access 2003 Database with a switchboard front end. What I want to know if I can do is when I open a report, if it is possible to code in a way for the user to highlight a field or cell, and to choose to change the text to a different color. Is this possible? Can anyone point me in the...

I have the time function on it, so when you first load the switchboard it shows the time it was loaded. Is there some way that I could have it update each minute or to reload so to speak? When I say clock, I mean a digital reading of the time, not a graphic clock.

Sorry for the vague subject, but I really could not think of a way to sum this problem up. OK, I have a database with a field titled Meal. In this field there are 9 possible choices: REG, N/P, N/M, C/F, BAG, Styrofoam, REL N/P, REL N/M, REL C/F. Now, I have a report that lists how many of each...

I have a query in my database, and I have recently added new possible entries for area. My report tells me how many male chickens vs. how many female chickens I have. Now with the new entries for area, I want my breakdown to EXCLUDE any chickens that live in a specific area. For instance: Pen...

I want my label to be R&D, but it turns into RD. What is the character to precede it to tell access you want the literal version? I tried \ and /.

OK, this is an example table, and example of what I need in my report. If anyone can help me figure this out it would be great. Very simple table: Employees Employee ID - Number Employee City - Text (Minneapolis or St. Paul) Employee Sex - Text (Male or Female) Employee Status - Text (Full...

I have a few reports that are automated through my access database, but I also have to edit it into a wordperfect document for back up purposes. Is there anyway to set up the report to be able to save in wordperfect format?

I have a database which tracks people's data. I have reports which are set up so each different person has their own page, meaning the page of the report is per person. Right now I open the report, and browse pages to find the person I want to print out. I do need the report to open with all the...

I am not sure if I do it in the query or the report. Basically what I want is this. I have a report that gets data from a query. I wish the report to number the results like below. 1. First Record 2. Second Record 3. Third Record How can I do this?

I will try to describe what I wanna do. I have a report I want to make which has only 3 fields of detail. If I do the report normally, with one column containing those 3 fields, it requires 2-3 pages to complete. I would like to have three columns on one page. I will try to draw out what I mean...

I can not make the link thing work, and now I cannot even make it work with the images being stored in the database. My DB is very simple, and I am attaching it, along with my Images folder and a couple images. If ANYONE can figure out my problem and suggest how to fix it I would greatly...

OK, I have 3 fields in my table: First Name (FNAME), Middle Name (MNAME), and Last Name (LNAME). The table is named EMPLOYEES and I need to make an expression that will give me an employees full name (LNAME, FNAME MNAME) in that structure. Now I created a new Query which included the three...

I know everyone is going to say DONT PUT IMAGES IN YOUR DB< PUT LINKS TO THEM IN! I am not at liberty to change the structure of what my boss wants, he wants the images stored in the DB so that is what I am giving him. My problem is this: I have a single form for entering data into my Table...

I have my form where each records image displays as you scroll through the records. I want to add a control similar to the file dialog control, where users can browse to an image file on their machine, and then preview it and Update it. Can anyone walk me thru how to do this?

I have code for a button click event. Essentially I have a main table form that I use to enter customer data and info. I also have a button that I use to add that customer to a separate table that I use for special Customers. My code copies all the data I need copied to my other table, so I wont...