Search results

One, this isn't a Word discussion forum. Two, If you use the spacers in the ruler (at the top of the screen), it should nudge it to where you want.

Thanks, jdraw! That helped immensely.

Ok, I take that back. I'm trying to use a list box form for the personnel, so I can select multiple trips they are on that way, plus the other way. However, they're not saving. Clearly, I'm messing something up that's very simple, but I can't figure out what it is.

Yep, that's what I was thinking, too, but saw that not all there code was there, so I figured it was something simple. I guess it was, more or less.

I believe you just had an omission. Try this: iif(IsNull([RoomNO]), [bkrmassigned])

You know, as I take a step back from all of this and look at it, it's actually really easy, I was just looking at it wrong.

Right now, I don't have any relationships setup. I have two tables, one for Personnel, one for Trips. For the Personnel table, I have MemberID as the Primary Key. For the Trips table, I have TripID as the Primary Key. I've built databases where I can add multiple records to an...

Just to be clear, I guess I should have specified, but this is not an actual Access Project, but rather a regular database. I do not have access to MySQL and simply want this to function as a regular database.

It's been a while since I've messed with 2003 in any complexity. I've got a form, we'll call Trips. I want to be able to create as many trips as possible (which I already have done). Secondly, I have a separate form, we'll call Personnel. This form has two functions. One, I need to be...

Great! Thanks for your help!

I have been working on a database, for some time now. One of the issues I have, is that for every new record, the next number in the series needs to be used. Now, I have records I create, and records that come into me that I track, as well. Here are the two fields I am concerned with...

I might have asked this before, but don't remember. I have a query that pulls a listing of personnel where I track their pending transfer date and any subsequent reports or other paperwork we need on them prior to their transfer. As of right now it will display every single annual report...

Thank you!!

But of course. Here's what I have, but keep in mind, I'm no expert. If Me.Report_Status.Value = 2 Then Me.Closeout_of_Last_Report = Me.CODLR Else Me.Closeout_of_Last_Report = Me.CODLR End If This is my first attempt at writing code from scratch. Be gentle.

I've got a form, with an option group. What I'm trying to do is update a particular date based on whichever value is selected. If the value = 1, it shouldn't do anything, but if the value = 2, then it should return next year's date. I've tried implementing this code, but for some reason...

Neither of these options are available to me on my network. Good info though, thank you!

My whole reason for converting it is to get away from having to enable content everytime the database is opened. Moving to signed VBA code, just makes it easier (but not on my end). :)

Big surprise, right? A converted Macro doesn't work the same way in VBA? I've got a Macro that will update a date field based on the users selection. As a macro, it works perfectly. However, I'm wanting to sign my database so I can rid my users of the Security Content warning whenever they...

The date range will always be the same, but I need more guidance on how to do all this. I know Access and am familiar with a lot of the functions, but some stuff is still a foreign language to me. EDIT: I suppose I should specify that these aren't Access-generated reports, but actual...

I had previously asked a question in the Query forum regarding dates being generated for reports where regardless of the due date, it would return a date of the first day of the previous month. What I want to do now is set something up that does the following: I have roughly 6 different...