Search results

Thanks for the reply. It looks good but I don't quite now what you are saying. Are you saying add ([OldDate],"ddmmmyyyy") to the Format property of the new text box? When you say run a simple query do you mean a query query or just reference the other textbox? I tried just putting the above...

You may also have to go to page setup in the file menu to change your margins. I change all my margins to 0 and access just makes them the smallest possible. That way what I see is what I get. Then as stated above you make sure your borders are not wider than your print area. Greg

Hello all, On our main results form the boss wants the date to show dd First three letters of the month 2005, so dd "Mon" yyyy. Medium date does dd "Mon" yy. I need the 20 for all of the years, (or 19 for past samples). When we set up this database a long time ago we just did date arrived as...

Hello all. The events of today have me scratching my head. I have a database that is 11k Front end (After compact and repair) and 180k Be (After compact and repair). The main form the users use to check in samples and enter results etcis chock full of fields and is two pages basically. It has...

Making a query based on my table is not the solution for this problem. I made a new form with just the SampleID field. As I scroll through the numbers they are out of order. I look at my table and it is definitely ordered correctly, but somehow in the displaying of records it orders them by a...

This didn't completely solve my problem. When I click the add a new sample button it adds the new sample after the last '99 sample id. It calls it 04-48234, which should be 99-48234 or 00-48234 not 04-73675. Still a major problem. Greg

So I made a query. It Works. Hopefully that will solve some problems. Thanks for the speedy reply. Still, if anyone has any insight into why my table would be ordered correctly but displayed out of order on the form, feel free to enlighten me. Greg

Why did this just happen? I can sort the records by short sample id (34567) in the table and that has worked flawlessly up until now. Making a query might work. Thank you. Any other suggestions? Greg

Hello, I am hoping for the powers of the forum to help me. I need this fixed fast too, our company is at a standstill for a while. I have a form where we check in samples that are delivered to us to be tested. This form is based on a table. the table has many many records as well as fields...

Beautiful. Thank you very much. Greg

I am making a form to calculate time sheet hours and pay. We sign in on our time sheets by hand (I don't know why but we do) and they want to be able to enter these times into a form and have it spit out the pay amount for the employee. Not so bad, so I thought. I am having them input time in...

I have never worked with charts but I beleive using a subreport is your answer here. Have your chart in the subform and just have the link master and slave fields be the product code. Then when you open the record on your main report the subreport matches. Vague answer but maybe it can get...

Could you post where you found the solution, or what you searched for to find this? I have been wanting to do this for some time.

What are carriage control characters? I am pretty sure it has something to do with the user. Would it cause a problem if one user is looking at the record while another is entering data for that sample? All of these are excellent suggestions and I will work through them probably starting...

I have a rather large database in Access XP. We have a main "CheckIn" form where we check in samples that are given to us to be tested. This form is bound to the "CheckIn" table. Every once in a while a record will become corrupt. I look at the checkin table and where the record is supposed...

If the control you are referencing is on the form you are coding you can use Me.MyTextbox.

The way I take care of it is by having my local database linked to local tables. I can do whatever I want to test and manipulate the front end, I can even change data in the tables to test things. All users have a frontend copy of the database on their computers linked to the backend on a...

Hello Access friends, I have a report with ten subreports. Each of the subreports have 3 fields that are percentages of a total, so classI = 30%, classII = 40% ClassIII = 30%. Each subreport has this same calculation (the subreports are for different criteria). At the bottom of my main report...

That is an excellent suggestion that I never thought of however, I don't want to set them to 1 and don't want to subtract 1 from all of them, only the counter that happens to meet the criteria for the first record of the page. Since we're on the subject of my painful report, this report has ten...

Right, I forgot that little bit. I have a global variable that corresponds to each counter text box. If Me.OtherElemnts <=5 Then sgCounter1 = sgCounter1+1. This is how it goes for the other two with the criteria being between 5 and 15 and greater than 15. I then set my text boxes on my...