Search results

Yes. Everything seems normal until I make an entry into the form and it is obvious that the underlying code does not run, but I get no error message. When I go to the modules I get the error messages I posted earlier. If I try copying the modules and pasting them I get an error saying that the...

Thanks for that. I have tried creating a new empty database and importing the modules one at a time, but when I try this, I get: “The name conflicts with existing module, project or object library.” By the way I run Access 2013 on Windows 7, if that is relevent. Clepto is online now Add to...

Thanks for that. I have tried creating a new empty database and importing the modules one at a time, but when I try this, I get: “The name conflicts with existing module, project or object library.” By the way I run Access 2013 on Windows 7, if that is relevent.

Hi All I have lost the modules in a database. When I try and open a module I get the message: “The module name is misspelled or refers to a module that doesn’t exist.” I have tried creating a new database and importing the modules, but when I try this, I get: “The name conflicts with existing...

Thanks for that, but if I did it that way, I would still have the forms and macros and there are none. As I recall, I set the cursor after the () on the first line of the sub pressed a button or combination of same and it ran.

I am sure there is a function key to run a VBA module [Private Sub X() ] but I can’t remember what it is. I set up a module to print some labels to screen, many months ago, and I am sure I ran it in this way. I have come back to the database and there are no macros or Subs to run this code any...

Sorry for the delay in responding. I work nights and sent my post after a frustrating morning. In short, I want to use date/time as a unique identifier in an order. Access stores date time variables as a double, which is a floating point number and in the interim I have found an item headed...

I have a similar problem. I am using Now() to capture a unique date/Time, to differentiate between an order and the update of that order. I want to keep the old order lines as an audit trail. However when I use the date/time as a query criteria I sometimes get no records. I say sometimes...

Brilliant! I must have been a character out a number of times. Thank you so much.

I have been struggling with this all morning, and it has got me stumped. I have established the variable “var” and I wish to use it to replace the integer “7” at the end the following SQL statement, which is contained in a string and works as it is. However I wish to vary this integer value in...

Yes. That looks like the best way. I had heard about the power of coding so I thought that would be the way to go. Many thanks

It was a shipping system for a pet products company in NZ. It did everything from the original order right through to costing products according to the space they occupied in a container. I never needed to use loops for this, so I never got into VBA. The the pre filtered subreports is simpler...

I am a self-taught Access developer working in Access 2013, who has created a number of databases, some quite extensive, but I have never needed to use VBA code before. I am developing a warehouse database to pick and despatch two types of products: packaged goods and perishables. Each type is...

I run Microsoft Office 365 Professional with Access 2013. Are there any bugs in this version of Access? I have a problem with a Combo Box with 5 columns. The first is ID and is set at 0cm. The other four are set a various widths, however, only the first visible column appears. If I convert to a...

I am a rusty, self taught, Access developer who worked regularly in Access about 15 years ago, at which time I created a fully intergrated shipping system for an NZ company which followed the complete shipping process, import only, from the intial order to the costing of each product, based on...