Recent content by randommetalguy

This is just a text box on my form. I am using VBA code to do the formula so there are no tables involved. I have already set Format to 0.0 and Decimal Places to 1 but 22 does not show up as 22.0. Datatype and Field Size are things I can customize with data in a database table.

I have a formulas that adds some numbers together. If I'm doing 5.5 + 5.5 I want to get 11.0. However, Access keeps saying it's just 11. How can I get it to show the zero after the decimal place? I've tried Fixed, 1 decimal and formatting to 0.0, 0.0, 0.0, etc but nothing is working. Thanks...

Hello, I've developed this program and sometime over the past 3 weeks there must have been an Access update affecting my program. When I run my program from the Form View I do not have any errors and my program runs fine. I have packaged up the file and reinstalled it and now whenever I try to...

I have two reports MainReport and SubReport. Sometimes I want to display the subreport and sometimes I don't. This is controlled by a VBA variable. Either way, whether the subreport is visible or not when I close the main report is makes entire Access shut down. I can go from ReportView to...

I have a desktop application. But is there a way to store the tables online so that one person updates some data in the tables and everyone automatically gets the new version of the data? I know you can split a database and have a database.accdb file and database_be.accdb file. Instead of...

It seems to be working for right now.

Alright, this issue has been resolved.

When I do that, I still have the blank page when it is small.

No, do you have a link for setting this up? I don't get any error messages about not setting having a trusted location set up.

I've downloaded the developer extensions and runtime environment. I've even deployed with and without runtime included in the deployment but I still get the same problem. It creates a accdr file and when I double click the file, the runtime environment opens but nothing happens. I've set up my...

I changed it and Can Shrink is now set to Yes, but I still have the same problem.

Hey guys, I have a three page report that I am trying to print. But, if the user does not want a diagram with the report then I set the diagram to visible.false. With all three pages (including diagram) the detail section of the report has a height of about 22". If there are only two pages...

Hello, I am trying to go from a form to a report and it's not working out how I anticipated. Initially I was going from Form to Form and could use docmd.OpenForm "formname", acNormal however, when I try docmd.OpenReport "reportname", acNormal it doesn't display the report, it goes directly to...

Well in the input form the user is designing up to three products. They will manually type a sequence of specifications and through table look ups and formula calculations, the items that are missing get filled in. Then you can temporarily save the product you are working on into a table and...

Hey guys, I'm having trouble exporting from Access into Excel. My database is set up like this. Input Form Table to store data from Input From Output Form that Grabs some data from the table and still makes a few additional calculations in a VBA module based on data from the Input Form. One...