Search results

  1. B

    Running totals not picking up report Filter

    Thanks Thank you SO much! this has been a problem for weeks, putting the where clause in the open report command solved EVERYTHING (I didn't know you could do that :)) Seems setting the report source on open causes alot of problems.
  2. B

    Running totals not picking up report Filter

    Hi all, I'm having troubles with a report I've created. You make some selections on a form which then sets a reports filter property and opens the report, this works fine. One bigger problem I've had is that any of my running totals are still showing totals as if there was no filter...
  3. B

    Viewing PDF files from within access

    I've been reading everywhere on this site trying to find out how to do this, but just can't seem to grasp it. I see people saying it can be done, but can't find more specific details on how to go about it. I just want to view a pdf file from within the access environment. I need to be able...
  4. B

    random insertion upon deletion

    I have an access 2k3 front end linked to a SQL Server 2k backend and have been having quite the issue with deleting.. I have a form with a subform, in datasheet view.. there are 2 combo boxes both of which are master links to the sub datasheet, now when I select a plant and a date, it brings...
  5. B

    help

    Hi All I have multiple tables... all with the same composite key. well the tables are all the same layout infact.. just each table has a different row of data in each for ex. table 1 ID field1 field2 1 test 0 2 box 0 3 three 0 4 can 0 5 meh 0 table 2 ID field1 field2...
  6. B

    date comparison

    Hey all, I've got to show records from a table that are 45 days old or newer.. im not quite sure how to do this in SQL ... Select field from table where date > (todaysdate-45).. as you can see..clueless lol any help is _greatly_ appreciated
  7. B

    Hiding columns in a subform datasheet

    Hmm I just tried that, it just doesen't hide it.. no error but it loads as normally and shows the field right there :( I tried hiding the field in design mode AND runtime neither work
  8. B

    combo box limitation?

    No, its not, but good thinking
  9. B

    Hiding columns in a subform datasheet

    Morning all, I'm trying to hide a column of a datasheet in a subform I have... if I run the form and right click and hide the column, it doesen't save that the next time I load it (wasn't sure if it was suppose to, but after reading http://office.microsoft.com/en-us/a...2362201033.aspx it would...
  10. B

    combo box limitation?

    Hi all, I'm getting an error "The setting for this property is too big" for my combo box when trying to load 2 columns (fields) of about 2,000 records using a stored proc (SQL SERVER 2000) to access 2003 as my front end. If i only load the customer number.. one field it does it.. but as soon as...
  11. B

    Reports not being created :(

    I've been trying to create a report, any report in access 2003, I'm working on an access project with a SQL Server 2000 backend. I have everything working fine, everything but reports, if I go to try and create a report in design view nothing comes up, it sits there idle. If I go to create a...
Top Bottom