Search results

Awesome! Thank You Banana!

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 /.

How do I get the ampersand character into a label? Thanks Roy, I finally got it to work. I sdont know what I was doing, but I just accidentally hit tab after editting it once, and then when I closed the properties box and checked the preview it worked. I guess maybe it was not saving the...

Also tried: =Count([Special Housing Unit Inmate Data Table]!Meal="REG") that did not work either, I still for value #error on the report.

I tried this, but when I preview the report for the count value it shows #error. I tried both of these statements. =Abs(Sum([Meal]="REG")) on that one, Meal is the name of the field in the table I have the report linked too. =Abs(Sum([Special Housing Unit Inmate Data]![Meal]="REG")) This one...

I'm not a pro, but have you set up the relationship for the two tables? I think once you do the relationship, you should only have to enter the parameter once.

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...

TBALDY, MUCHO GRACIAS!!! I went to msdn and looked up the openreport method, and found that I had one too many commas in the statement. It works perfectly now, and I very much appreciate your fast and good assistance!!!

Actually the number field in the table is a text field, as it contains non numeric characters. An example is 12345-678. I did however try it both ways and it still says type mismatch in both cases. Would it be better if I used a different field to do the select with? Could we use just the...

Thanks pbaldy, I put it in but I get an error now. Private Sub NEWBUTTONTEST_Click() On Error GoTo Err_NEWBUTTONTEST_Click Dim stDocName As String stDocName = "Special Housing Unit 292 Alpha Report" DoCmd.OpenReport stDocName, acPreview, , , "Number = '" & Me.Number & "'"...

I tried to do this by creating a separate report, built to open only a single record, using a different query as the data source. On my query I made the condition for number "= Me.Number" but it didnt work. When I clicked the button it threw up a parameter box asking for the value of Me.Number...

Well, I dont know any VBA, what I took from the other response was that I could make the buttons click event open a macro, which is where the openreport properties would allow me to use the wherecondition setting. I have no clue how to make an expression, let alone make one to select only the...

I have no clue what Lotus 1-2-3, autodesk or Kaypro is... and I have no clue how to mess with extended memory. As for using Wordperfect, I work with the Department of Justice, and that is the format we use. I prefer word, but most computers do not run it. If I was to export it as a Word...

How would I make the expression? I am not good with SQL Code stuff. All I would need is for it to open only the current record. Where name = !me.name ????

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?

AWESOME!!! I will try that out! Thank You!

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...

OH MAN! That is EXACTLY what I did. Two things actually. 1. I found the file size limit on uploads, and even with my basic empty db with just one form it was like 10 times the limit. 2. The computer I was working on at the time only had the basic access installed, I did not do the full...