Search results

Problem solved using joint query from more queries...

Thanks a lot, I did a Debug.Print and found out, that my real problem was, that it actually didnt change the format into US (from UK) - so other way round. :o Problem solved now. Thank you very much!

Thank you for your prompt answer! I put away all the .Value, but nothing changed. I still get the records with dates before as well as after the interval :(

Hi, I tried to use CDate for the change of time format from US: MM/DD/YYYY to DD/MM/YYYY in one form, where I state start date and end date in order to get all the records between these two days. I don't know, what I did wrong but it's still not working properly and I get records also out of...

I am sorry, I know, I am just newie, but I wasn't able to find the answer for my question. I know how to return all the existing dates in the records of a particular table between two stated dates. My problem is, that I have to create those dates as a new records in that query (or joined table)...

Hi, I have one major problem and need to solve it, please help. I need to design query, which would return all dates between certain two dates in format year/month. I just need this let's say 'one field' query - the query has to generate the dates, this is the problem. I have to generate all...

Hi, I have a huge problem designing a chart, where more lines (series) will be displayed. I tried to use PivotChart as well as chart object in the insert menu for forms. The problem is that I have to use conditional count for every serie/line. I based my chart on a query (based on another...

Thank you very much, problems solved, thanks. Ivan

Hi all, I have several issues with my form. I designed a command button for saving the actual record and doing more things in background, please take a look: Private Sub Command194_Click() On Error GoTo Err_Command194_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

You are right, thank you very much. Unfortunately in this case I can't avoid combo box. Thanks once more.

Thank you, you are right. There's no limit to the rows. However I still have the same problem. I get two error messages when I try to save the table after I did the dropdown list using the lookup wizard. I did the screenshots if you want to take a look. Thank you once more, Ivan

Hi, I am quite new to Access. I found out, that there is a limit of 250 rows per dropdown list. Can I overcome it somehow? I need to have 281 rows. I used lookup table with just one field as a list of these entries and then made a relationship using lookup wizard between the main table, where...