Search results

Right then . . . . I have a spreadsheet with a list of projects (in 'active' and 'on-going'), each project has a main title and many minor titles (sub sections). Each project will have a different number of minor titles. The user can then enter how many days they have worked on each minor part...

Hello all you good good people! What I need is a macro button actually on the page so the user can click it and it copies and pastes something that's already on the page. See attached example. What I need that button to do is copy the entire table and past it underneath the one that's already...

Hello I'm guessing that this question has been asked alot. How do you get rid of the options at the top of the screen so the user cant change any of the underlying database management design? I've created a blank menu macro with nothing in it and put it in the properties of each form but this...

Hi, Can someone help me please? I need the text in the attachment too scroll across the text box. I've searched the forum's and found some info/code on how to do it but I've not really understood it. Thanks - help is appreciated! Rich

I've search the forum with no luck. I know you can search for part words by using one of these types of code: Left(stringexpr,n) Right(stringexpr,n) Mid(stringexpr,start,n) How do I do the same with numbers? I want to extract every thing past a decimal point. For example, I have 5.912 in a...

I've attached an example access 97' database. I need the unbound "Estimate of duration" box on the right to automatically update the "Duration" box on the left. Any ideas cause I'm all out of em. I have a feeling that I don't need an unbound text box at all and I just need a bit of code in...

Hey Kids, How do I create a line graph on a form? I have a query that extract's the number of something issued over time. The query looks something like this: YEAR: 1999 2000 2001 2002 2003 2004 ISSUED: 5 6 9 13 10 8 I want a line...

Hello there you fine Access programmers. I have a problem with a list box. As you can see in my Access 97' attachment, I have a list box that updates certain boxes on a form. What I need is for the user to be able to narrow the search (by the court name field) in the list box depending on...

Does anyone know how to put a button on a form to export the data in a certain table to SAS? Thanks

How do I use a form so the user can enter a record straight away? At the moment, when the user enters a form it open's at the start of the records and to add a new record they have to press "Add New Record". I want the form to open so it's ready to accept a new record straight away. Thanks...

How do I password protect certain button's on a form? I have a delete button and I only people who know the password to be able to delete records.

Here's an easy one. I know what to do but I'm usure of the wording in Access: What code should I use on the click event of a button to paste a numeric value from an unbound text box to another field on the same form (the button will be on the same form). Assume that: The unbound text box you...

In a vbokcancel msgbox, how do I get the cancel button to stop running a sub (i presume exitsub) and the ok button to run a macro. This is what I have so far . . . . MsgBox "This will bring back details by MCC between the dates " & Forms!Frmmain!txtDate1 & " and " & Forms!Frmmain!txtDate2 &...

I have a form with an unbound txtbox. The default for the txtbox is "01-Jan-1900". I don't want the user to see this date but if they change it then they should see it. In the before update action for the txtbox I put in this code: If Me.txtDate1 = "01-Jan-1900" Then Me.txtDate1.ForeColor =...

I have created a form but I've missed off a field in the relevant table . I went back and created the new field in the table and went back to put it in my form but its not in the field list at the top of the form design screen (next to the tool box). How do I add it to my form? Please don't...

Hi, Is there anyway to decrease the size and therefore increase the speed of an access 97 database? This is my first real go at creating a database and as you can imagine I have created and deleted alot of forms & querys that I haven't needed and this (I think) has increased the size of my...

When two dates are selected and the gender button is pressed, it brings back a form based on the query (I.e. the number of records between the two dates given by gender). All I need is the two dates that appear in the unbound text boxes (ealiest and latest dates) to appear somewhere on the form...

Please help meeeeee! How do I get error msg to appear? I have a button on a form that runs a query. The query relys on 4 text boxes to be filled with data (the first two being two date fields to show a range of dates and the second two being two integer fields showing a range for age). Once...

I know how to make one field in a table mandatory (required). How do I make one of three required? I've got three fields: Date of conclusion OR Duration OR Untill further notice The user HAS to enter one out of the three. Help on this would be greatly appreciated! Rich

I have a form connected to a query that uses a pop up box for the user to enter two dates DD/MM/YYYY. I have: "Between [Enter first date] and [Enter last date]" typed in the criteria section of the query. The query brings back records I have defined between these two dates. What I need is a...