Recent content by HAFPT

We have built an Access database that allows our compnay to supplement our ERP order information with shipping and letter of credit information. We now are looking to develop a web front for our salespeople and Access doesn't seem to support this. Do we need to learn another tool (like Servoy...

I was doing a compact and repair when I got this error message. Now when I try to open my database all I get is this message: "Module not found" :eek: Am I screwed or is there maybe possible silver bullet?? Thanks for any help

Thanks dcx693 :D this string compare was great, I just used it in a query, works like a charm. Had the same type of problem, I'm looking for data entry issues in our ERP system, Address Book module.

Thanks for the additional ideas and code I was just looking at your AuditTrail example

I have a form that allows the users to Search to find Leter of Credit records already entered into the DB. From this from they have a button to delete these record too. I want to add in an audit trail to the delete function so I the Admin knows what Letter of Credit records were delete but...

Looking for some help on a Mail Labels database I'm working on for a Paper Company. I created a form for the user to select what Address Book records they want Mail Labels for. The form has three criterias, two text boxes for Address Type and Country then I have an Option Group with Option...

Thanks for the info. From your info we do have Citrix setup this way. So there must be something else wrong. :confused:

We took one of our Access databases and are trying to run it on a Citrix server for remote users. Everything was working well until we tested having more then one user on the database at a time. We can only seem to have one user on at a time. There must be a setting or some type of security we...

Doesn't look like it from the Access side through the hyperlink. What if you create an autoexec macro when the spreadsheet opens to goto the cell or sheet you want to go to. I haven't done but it is just a thought.

AndyJ that is how I close the DBs too. KenHigg's comment is the one that I know to stay away from. But sometimes the users get knocked off by something else they are doing which is something you can't get away from.

I've run into the same error message and I too try to make sure the users know how to close the DB properly but I still get it every now and then. I have not been able to link it to anything in particular. But what is interesting is if some users are in they are not affecting only users trying...

Thanks Jings00 and Pat. I was able to do what Jings said to do. Just have to make sure everyone is out then its does seem to let you delete this file.

This is the second time I have not been able to Compact and repair our database do to this Access.LockFile still open. From my understanding this keeps tack of users on the database and goes away when everyone logs off the database. Does anyone know how to get rid of or around this file?

Oh yeah, I forgot something, to automate this add a command button called "Mail Merge" to your form that calls a Macro. So for the Command Button properties event On Click event = DoCmd.RunMacro "macro name" (<just the name of the Macro in the " ") Create a Macro with 2 Actions: 1. OpenQuery...

Create a make table query and you can link the form to the query's critera using [FORMS]![formname]![formfield] to use the filed selected in the form to drive the query data selection (where statement). This will create a table with only one record which then can be merged into Word. Does this...