Search results

Search CDO

Something I've discovered early on in my database development. No matter how many precautions you take, if there's a hole (errors, security, etc), your users will find it. Especially in multi-user environments. There are many good tutorials on this site that help alleviate that and as a previous...

This may be a dumb question, but I can't seem to find the answer. Is there a way to round the bar/column corners on the chart? I don't mean the chart area, but the actual bars/columns. (Excel 2003) Thanks, Craig

Try this: http://www.techonthenet.com/access/forms/custom_error.php

OK I got it to work using the following code: Dim DBS As DAO.Database Dim TBL As DAO.TableDef Dim FLD As DAO.Field Dim REL As DAO.Relation Dim WKS As DAO.Workspace Set WKS = DBEngine.Workspaces(0) Set DBS = WKS.OpenDatabase(txt_Path) Set REL =...

I'm having a little trouble getting this to work... I'm trying to create a one to many relationship with both update and delete cascading. The code runs with no errors, but the relationship is not shown in the relationship window as being created. Does anyone have any pointers? Dim DBS As...

Well, I am still searching for an answer, but I thought I'd post while I continue looking. I am creating an "update tool" for an existing database. What I am trying to do is add a field to an existing table in a database from a user specified location. Example: User browses for the existing...

Thanks guys... I've decided to store this as a string using an input mask. I'll then convert the string into seconds when it's time to calculate. Should be pretty straight forward as the digits will never be greater than the mask allows. It's not really what I had in mind, but it works.

Hi all, I am using a date/time field and I want to customize the format such that I will show minutes:seconds.milliseconds. In excel, I am able to create a custom format like this: mm:ss.00 I would like to do this in Access, but am having some difficulty. Anyone have any ideas? Thanks, Craig

Gotta love the Lebans code for outputting a report to pdf. ;) Search "Lebans PDF" and you'll find it. For attaching to email, use automation. Tons of stuff on it in here.

You might want to look into regular expressions http://regexlib.com/DisplayPatterns.aspx?categoryId=7&cattabindex=2 Though I am not sure you can check to make sure it's a valid prefix for the area code, etc.

Well when I create large databases, I tend to put objects in groups. If you right click on an object in the DB window, you'll see. For revision control, you can do something simple and create your own "revision table." For revisions, you can use the auto number. I know it doesn't follow...

I use subforms a lot in datasheet view. It sounds like this is what you are doing too. Perhaps one of these statements will help: DoCmd.GoToRecord acForm, "YourFormNameHere", acLast DoCmd.GoToRecord acForm, "YourFormNameHere", acNewRec Or maybe the "setfocus" command will better suit your needs.

From the sounds of it, you have a sub form with in a form and the sub form is in datasheet view. Is this correct? If so, I am not sure if it will work if you move the code to the main form "before update" event. If this is how you are set up, I do it the same. I call the audit trail in the sub...

Another option is to create a new form, create a command button, then put the above code in the on click event. Then click the button on the form. Can you get into the db using the bypass key? If your original code is in your startup form, it'll disable them every time you open the db.

Boyd, I can duplicate this in: Access 2000 which I have here at work. Access 2003 which I have at home. I am unsure of the other versions. I suppose I could try it in 2007 runtime to see what happens. Craig

If you are trying to output the single report just replace Me.lstRptName with your report name. So if your report name is for example rptStatistics you would put "rptStatistics" in place of Me.lstRptName Remember to use quotes.

You are welcome. You should be able to duplicate it very easily. Export a report to PDF or a table to excel with only the application window visible. If also found that this happens when I try to output a table to excel when nothing is visible. I have another DB that the user wants to output...

I use Leban's code as well, though I found I had to modify it slightly. It's usually my preference to construct a menu bar dedicated to the application I am building, so at times I may export a report to pdf without having any forms, reports, or db window open/visible. Doing this generates error...

Well, I know that I will need to have a user id and password to send through the server. For some items it won't matter who sends it. An example would be an auto email for open items for the users that need to approve them (Document revision approval). In this case the generic would work. The...