Now I am getting a #Type! error
Now I am getting a #Type! error
getting a #Type! error
You need to show what that DateValue is using in the ControlSource?
If Mydate, then I would have thought you need to use another name for the control?, otherwise confusing as hell.
Just upload the DB as requested in post #16 please, this is at 32 posts and we have got absolutely nowhere.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Here is what I have
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Here is what I have
I changed the field to LiquidDate as you still had it as Date?, so MyDate was never going to work.
You will get an error when you add a new record as the date field will not have a value.
However I thought this saga was all about getting rid of the time element from a field so as to export to BI.?
You have no time elements in what you uploaded?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Ok, it has finally sunk in what is happening.
There are no time elements in your date field, Access itself adds them as 00:00:00 when you export. :(
So you need to find out what format BI expects dates to be in and format to that format. A quick google shows that people recommend importing as text and then creating a date from that?
However I would certainly look to see how BI expects a date when importing.
You are on your own with BI. :)
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Suggestions:
Object names should be letters and numbers.
Do not begin an object name with a number.
NO spaces, punctuation or special characters (exception is the underscore) in object names (Field, Table, Query and Form names)
Bad field name: "Liquid Amount (Gallons)" AND has spaces
Better: "Liquid_Amount_Gallons" or "LiquidAmountGallons"
Also why the csv route?
Apparently PBI can link/import just like Access?
https://www.google.com/search?client...rt+from+access
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
FWIW I downloaded PBI Desktop and used it to access your TestDB
It appears to only recognise tables, so you would need to create one for your output.?
However it is vey slow on my old laptop, so I left it to go and get a passenger.
When I returned, no error message.
I have no clue how to see that data in PBI, but it appears to have been imported/linked without any issues?
So perhaps try Access direct? You have to click on the More option to see Access database.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Ok I will try this
Crossposting the same query after 30 plus posts, is not what I would call 'ok, I will try this'
https://www.accessforums.net/showthread.php?t=86422
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Sorry, I didnt mean to cross post but I sense your patience is running thin with so many post. Just trying to figure this out.
Maybe what's needed is a higher level description of what you are doing and what the outcome needs to be. So far, this seems to be like
"I need to do B. I have already done/set up A"
Sometimes the problem is really A and there is a better way that avoids having to do B. Can you provide a description of the process involved in this data management?
Might be a good idea to mark the other thread as solved so that people who are unaware of this one don't start asking questions in the other one? Then we can see where your description takes this. It may very well be that a new thread is warranted, but I'd say not until we know more about the process.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.