Search results

I was wondering if there is simple way to do this. I have a single 'text' box on a form that captures test scores. The person inputing the test scores puts in all of the scores separated by commas (77, 85, 100, 75.5).. Up to 6 test scores can be placed in this single text box. The field is...

I was wondering if anyone had a quick fix. Not a huge problem but is annoying. I have a fairly large table with approx 15k records. I have a form where I have a drop down/select control box that displays all of these records showing a few of the fields. I select one of these records to...

I have 2 things that I would like my form to do if anyone has a solution that would be great. My database tracks daily activity at work and one of the forms has 3 fields for tracking postage used throughout the day and keeps a running balance as the postage is being used. So the form displays...

Hello. I was hoping someone would know how to make it so only one (01) on/off control in a form can be set to -1. I have five (05) of these fields in my form for answers to select in a survey I am giving. (Answer1, Answer2 ....) See that attached form. I wish it would work so that If one is...

Hello out there to the many Access gurus. I have an Access 2007 Database which I have been working on for some time and works fine on my local network at my office. I am now ready to beta test it and would like to set up a few front ends on different computers in differnet locations that are not...

I have several forms that are used to input data and run reports. Some of my forms have numerous buttons that each run a single report of one kind or another or open other forms. I would like to change all the buttons to a couple of drop down list so that I can select which report or form I want...

I was wondering if someone out there can take a look at a control box I have in a report which I am having difficulty getting line breaks in. I would like to separate each control with a space ([Observations], [Commendables] and [[correctiveActionRequired]) as well as a line after some text...

Hi there. I am creating a form that will (hopefully) be a control panel for conducting conference call meetings for my company. Does anyone know of a ready made form that performs this function (creating agendas and minutes etc). I am stuck figuring out how to make a subform to do this...

I was wondering if anyone knew a way to return to the same record that was just created after a requerry. When I enter a new record in my 'ENTER DATA' form, the record does not show up on the Main Form until after I requerry (which is a button on my main form). However, the 'requerry' puts my...

I have 2 forms. One has all the fields locked so no one can change anything from inside the form. I have a button on the form that opens up an identical form but not locked so one can enter a new record. When I save and close the 2nd form, the 1st form will not show the new record until I close...

I have a report that is used as a check of list of sorts for auding purposes. I would like to inlcude a 'Comment area' in the report after each section. I want to be able to type in comments in report view and have these displayed when report is printed. I tried using an unbound Label but...

Hi everyone. I know there must be an easy way to do this. I have a report that displays the records of personel which also displays a small photo on the right side of each record. I want to be able to click on the photo and enlarge it. I can create another form or report with the picture...

Anyone know about combo boxes? I have a form based upon a query from a large table. The form displays a certain number of records based upon a button I selected on another form with specific criteria of one or more fieldss. I would like to be able to show and select from the combo box just...

I have a form where I can select different cities to display local customer info for that area that is inputed by an office worker in that city. I use a query that lets you select which city to display info for. With the help of this forum, I figured out how to display the current or local...

I have a form that displays various cities information for my firm. Each record is a different city and the form displays information for that particular area from a querry and users can input/update this info. I would like to show the local time for that city somewhere on the form. (I would...

I have a form where I need to open it based upon the present date. The query has a date field in it. Each day is one record and cannot be dupicated either. So basically, I want to be able to have the form open and point to either a new record - Now()- and also reopen and point to dDate=Now()...

I have a form that tracks daily data and auto sums this data for the day in another area on the form. I would like to display the montly totals as well for the month that is presently displayed on the form. Is there way to do this without using a querry. I would like to simply calculate this...

When I attempt to append linked tables to my database I get an error message that indicates an INSERT INTO query cannot contain a multi-valued field. The linked tables are identical and should work. Is there a way to append a table that contains multi-value fields? I have spent a lot of time...

Any ideas? I created a fairly large DB and now want to deploy it to 20 other locations around the US. Is the best way to use SharePoint 2007 or is there a better way. I was going to install the DB at all the locations as a standalone but then thought there must be a better way such as...

I have a report where I have several text boxes and Labels that I would like to place inside a rectangle or something similar so that they are enclosed together in the report with a nice border around them and will stay within this border. The rectangle needs to shrink or grow around the labels...