Search results

Thanks Bob - points to ponder over the holidays. One question I have - I seem to recall reading in the forum that a split database can't be compacted and repaired. Is that true? If it is how do you get around it? I hope you have a good Christmas and didn't get too much of that nasty weather...

I have reached the point in the database development where it will be loaded onto a server. What are the advantages/disadvantages of splitting the db to be/fe vs leaving it intact on the server? The db is to used load five excel spreadsheets. Otherwise all activity (reports, forms etc) is...

I did some more searching on Google, and found this - which DOES work. DoCmd.OpenReport "ReportName", acViewPreview DoCmd.RunCommand acCmdZoom100 The key was using acViewPreview NOT Maximize (by the way a side effect was maximising everything - which I didn't want. DoCmd.OpenReport...

I am using Access 2003 This is an old thread on the topic I am trying to resolve. I have tried running this from a command button, but I still get the error "acCmdZoom100 not available right now" Any other suggestions?

After several hours of frustration I finally did a search on the VBA code - I had the tab visibility set to no buried in an on form open event. Some people should not be allowed in VBA without a chaparone!

I am using Access 2003. I am going batty with this one. I have a form with a three page tab control. On two of the pages I have subform controls. The second tab page behaves normally. The third tab page is not visible in form view. At one point I had the form open with the third tab not...

Yeah - I like their site. I have used their tutorials for a number of different things. I came up with a quick kludge. I used an update query to change the empty fields to -- and added -- to the field list.

I have an unbound combobox on an unbound form that I use to search for records by province. This is simply a value list that the user selects from. The result is then used by a query with frms!frmGetProvince!txtPROVINCE. However not all entries have a province - ie the field is empty. How do...

I have played around with a sub report, but not effectively. But you have given me some ideas. The repeating field is not in a child table, but could it be done with a query/sub query? That will be my next attempt. I will look at that on the weekend.

Is it possible to do columns within columns in a report? I have a report with three columns on the page. There is one field in the detail section. There will be several hundred or more items in the field. I have a roster list of companies and contacts with the file numbers associated with...

Lesson learned - I shouldn't try this at 11:30 PM! iif([country]="Canada","",[Country]) works perfectly in the FIELD. Thank you for your help.

City/ProvinceState/Country are in separate fields.

I tried that already, but the query comes back with only the countries that aren't Canada. I need to see the records with Canada in them - I just don't want to see the country name Canada in the record's field.

I know the title is confusing - but it is only fitting since I am confused. I have a query for mailing addresses. What I want is to have a null value if [COUNTRY] = "Canada". That is I only want to see the country if it is NOT Canada. This is not the same as <> "Canada" or Not Like "Canada"...

It did. But I am happy with what I have.

I reiterate (thank you search!):

I wonder if <> ("CANADA" AND "USA")? I will try that one out. I did get it working using your method.

That did it. At least now I don't feel so foolish.

That didn't work either. I also tried a simpler form: =IIf([COUNTRY] <>"CANADA", [TELEPHONENOTUSCAN], Replace(Format([TELEPHONE] "###-###-####"))) This doesn't give the USA phone numbers, but it will others: =IIf([COUNTRY] <>"CANADA" or "USA", [TELEPHONENOTUSCAN], [TELEPHONE]) And I tried...

Of course! This seemed the simplest way for ME to get to it to work. Thanks.