Search results

Yes, color printing is verboten here, so I never use it. All of my reports up to this point are basically lists, so no images, or charts yet. We don't have a formal document format, though we do use a couple informal conventions for some of our documents, so replicating that is something I'm...

I'm no graphic designer, and I'm barely a passable Access database designer, but one thing I'm always disappointed in are the look of my reports. I would very much like to hear ideas on how to make reports more professional looking.

Yes, and this is the first time I've ever done it this way. The list values will never change, so I figured this was the one time it would be OK to do. As I said, I found a workaround. I'm more curious how the list gets tied to the table field forever. Among the things I tried were to...

I created a combo box on a form bound to a table field, and I created my own list. I realized later that I left a member off the list. After much fiddling around, I finally was able to fix the Row Source after I changed the Inherit Value List property to "No". Creating a new combo box carried...

Wow, lots to digest here. Thanks everyone.

1. I hadn't even thought of the idea of drop down boxes, that would help. 2. Yes I am using a string for this. My own lack of skills led to this. My original intention was to just use a calculation of the present date plus the expiry interval, but there were a couple problems. First, the...

I have an Access application that requires a date input in this format, YYMMDD with the day being the last day of the month. This date becomes part of a bar code as an expiry date code, that gets printed on a label. I have guidance text right above the textbox that explains how to input the...

syschech, I am going to try that if for no other reason than to learn something, but here is my latest update. I started playing around with other queries tied to the tables in question, and what do you know, a different query tied to the InvReportT table exhibited the same behavior, of...

Thanks. On my end the behavior is the same. Running the query from the form works flawlessly, any attempt to edit the query in Design Mode causes Access to crash in the same way.

Update: I ran Office repair on my PC, and it still crashes. I ran the DB on another PC with Access 2013, and it crashes. Now it *only* crashes when the query is in design mode. I can run the query and its associated objects as part of the application, either via an accdb, or accdr FE, and I can...

I haven't had the problem in other databases. I haven't tried it on another PC yet. That is definitely worth exploring. The receptionist has Access 2013 on her PC. I'm going to see if she will let me take over her desk for a bit. I will also take a look at Office Repair.

Access crashes while I'm in design view, *if* I make any change. If I'm quick, and Save/Close the query, I can usually get away with it. Sometimes not. Here's an example. In the DB I attached, I added the InitiationDate field from the InvReportT table. Access immediately crashed. I reopened the...

This isn't even in the wild yet. I intend to have all the users have their own copy of a run time front end (accdr).

Thanks for your replies. No calculations are taking place. I converted the Run Query button to vba with no error checking. It only has the one DoCmd.OpenQuery line with the two options for view and editing. I've probably ran it 100 times or more, and not a single crash. By way of testing, I...

Can anyone take a look at this and provide some insight? This started happening about two weeks ago, and I can’t seem to find the root cause. Here is the scenario I have a set of causalities that can be attributed to an event. The event is documented as an Investigation Report{IR}. (Table...

I almost always create a login form, and have always just used the password input mask, and let users create whatever password they like, but I have often wondered how to create an improved password requirement, i.e. at least 4 lettesr, and 4 numbers or some such, but have never been able to...

Sorry, I think I used the DateSerial moniker incorrectly. I meant the date as an integer, for instance in this case, a field of type Number, a default value of Date() and a Field Size of Long Integer (I assume that's what CLng means), as you both noted. You two have given me some great answers...

A couple years ago I took over maintaining a preventive maintenance DB. There is one aspect I haven't been able to fix. To say I'm not the most qualified VBA person would be an understatement, though I know enough to believe its the answer to this question. One of the functions of the DB is to...

Scroll Bar to Neither did the trick. Thank you very much.

This has been a small annoyance since I started working with Access a few years ago. I've dug around properties, and tried all sorts of different things, but have never been able to figure out the cause. I'm sure its probably something obvious I missing, but I would dearly love to know what...