Search results

You mention this is a Date...however talk of 36 something. Therefore, I suggest you expand on your thinking/logic.

No probs. As long as you now understand what's happening.

Something like: Format([DateField, "yyyymmdd") Like [Enter Year] & "*"

Look at the attached. The form will let you put some sample data in. qryExample pulls all your data together.

It's the same principle in that each method - my two, and your own problem - all use the same function.

My example mentions Department, but it's just an example. You can create whatever you want in the Permissions table. Then you can align them with any User Level in the junction table. I have created many more permissions in my actual database (CanViewReportMenu, CanViewAdminMenu...

Here's a take on what I've done recently. Any questions, ask away. First, some tables: tblPermissions PermissionID Permission PermissionCategoryID PermissionCode DateCreated UserCreated DateUpdated UserUpdated DateExpired UserExpired tblPermissionCategories PermissionCategoryID...

Something like this.....? There's two examples in there. One on a form, detecting special characters as you type; and the second used in a query to determine if some text has special characters or not.

The Nz() function is what you want. Nz being Null to Zero. Nz([Your CC Field])

Sounds to me like a normalisation [read up on it!] issue. It sounds like you are sourcing your combo from a field in the table your choice will eventually go. Ideally, what you want is your table where the data is being entered into, and another table where your combo data is sourced from...

If you press Alt+Return in your formula, you can move different conditions to new lines in order to space it out a bit.

In Access/Outlook 2010, I just add a reference to the Outlook library from Access, and use VBA to send emails. Don't get given the Outlook warning, like I used to back in the Access 2000/2002 days.

For a quick but of dark fun, check out Limbo on Steam.

You could do something as rough as entering [ENTER YEAR] into your query criteria. Personally, I'd use a combobox on a form, with a selection of years, and let the user pick one of those years, then let the query refer to that combobox, like [Forms]![MyFormName]![MyComboBox]

Try: Format(DateValue("04/03/2015"), "mm/dd/yyyy") It probably doesn't recognise the string as a date in order to format it appropriately.

Keep it as a number field. You only need Format it to 0000 when returning it in a query or binding it to a control on a form or report. If you're entering directly into a table (heavens above!) then you can set the field's format property to 0000.

First of all, you talk of fields. But we're in the Forms forum. Therefore there should be Controls bound to your fields. So, is the Status a combobox with options of Active and Closed? My other question is why you would need such a field in the first place. If your date is entered, your...

Two ways: 1) You can make it a text field, and whatever you type will be stored. 2) You can ignore the fact that all the leading zeroes disappear and, when actually needed, format the field like so: Format([YourField], "00000") Personally, I'd go with option 2.

Someone linked to this the other day. I thought it helpful enough to retain.

For those of us who can't get to google drive because of network security, can you post the database as an attachment?