Search results

Thanks! There was one missing reference, which I un-ticked... and miracleously the Form opened and all is working like it should... so far :) Greetings, Michal

Hi, I have a front end file with all my forms which is linked to a database. I've created it using Access 2010 and there I have no issues opening it. My company has recently updated all computers with new Windows and Office and I'm having issues opening my program in Access 2013. When I click...

Paul, Thank you very much! That certainly helped and the code works fine :) Best regards, Michal

Hi, I'm saving my report as pdf and have written some VBA which exports the report to my desktop and assigns a custom name to the report based on the username and current date. It all works however despite my Win7 system date being correct the Date in code returns 22-11-2002. I think that I...

Hi, I have a lessons learned database. One field is called KeyLL i.e. it defines whether a LL record is a key one or not. I need a cirteria on my query that makes it possible to display both "Yes" & "No" values for my KeyLL field. On my search form I have a combobox called CheckLL where I...

Hi, I need some help with the following, hope it's doable. I have a form which I use to add / edit records in my db, both within a navigation form. The subform lists all 'not-yet-approved' records. I can 'call' a record from my subform by clicking on it and then clicking on an Edit button on...

Hi, Thanks, that's what I did... I left LessonsID and went straight to [Lesson Title] after SET. Now my problem is that my subform from which I initially get the data to edit in my form won't reload ... instead it just goes blank. After updating the record I clear form (CmdClear_Click) and...

Aleni, thanks, you're probably very correct. I have noticed it and now have all the fields in there. Now another problem pops uup... :rolleyes: Run-time error '3113': Cannot update 'LessonID'; field not updateable. I think it's becaus my LessonID field is an Autonumber type field. Any...

Thanks jzwp22 ! I've changed the date name to LLDate and updated the syntax in VBA by using # intead of '. My date field was in fact a date/time type filed. Now I'm getting another error: Run-time error '3061': Too few parameters. Expected 1. I have a filed called KeyLL which is a...

Hi there.. I'm going nuts here with that code and can't find the error which obviously is somewhere there. I have a data entry form which I want to use for entering new data to my database or to edit the existing records. I have a subform which lists only records marked as 'proposal'. I have...

Hi, I still haven't solved my problem :( Is anyone able to help me out with the issue in this post... I got stuck and I'm not sure what I'm doing wrong. I'm trying to implement some if / then condition into my VBA but I'm not able to make it work. I'd very much appreciate your help on this...

Yes, in a way... when choosing options from combos you create a query... the point is that you can search after just one record or a combination of records. I attach the screenshot of the query design... it is 2 files as it's too big to show it on one screen... but I hope it'll give you an idea...

Allan, Thanks a lot for you reply. That link is pretty useful but it is not exactly what I'm looking for. My form is based on comboboxes which link to fields in my database and retrieve distinct entries e.g. for Field Names, Well Names etc. I've managed to make them dependent on one another...

Hi there, I'm new to this forum and I hope someone will be able to help. I've built a search form and a query that looks for data in a lessons learned database called LLIS. I've attached a screenshot of the form. I've designed the query so that you can choose one or more fields and make your...