Search results

Ooops, good catch, Doc. I did not see that errant space in string.

Yes, but as I said, Access dropped the space in my concatenation test. So no idea why OP still gets spaces in the concatenated string.

Nice attempt to normalize db from Mike. However, not quite understanding the relationships yet. Also, report does not work now and will likely involve a CROSSTAB query to accomplish same arrangement (and this presents new headaches to deal with), otherwise a complete redesign. So the question...

Don't know why there would be space. In my test, Access drops space from positive number when concatenating to string. But using Trim() function should take care of regardless.

And now I remember you - "only 1 user at a time". As I said, then code needs to be more complex. But just do the manual navigation for now to test the report output. Time for me to hit the hay. Will look at again next day or so.

If there are multiple users and they work simultaneously, this db should definitely be split and each user run their own copy of frontend. Could there be multiple records for each date? And why could you not navigate to desired date, regardless of how many users there are?

You need to navigate to that record first. Otherwise, code will get more complicated.

It is just building a string so if MYURL is declared a string type, this should work. Type mismatch on what? If you want to provide db for analysis, follow instructions at bottom of my post. Or at least provide complete code. And please use CODE tags.

Okay, the field is named D_Date and the textbox is named txtDate. Which means your code is backwards. Review post 6.

You need to concatenate. You are not showing any concatenation. MYURL = "https://api.openweathermap.org/data/2.5/weather?lat=" & Me.txtlatSouth & "&lon=" & Me.txtlongNorth & "&appid=XXXXXXXXXXXXID"

If you want to provide db for analysis, follow instructions at bottom of my post.

Is the field really named txtDate? Is this a date/time type field? Looks like Me.D_Date is Null. Did you see my previous post?

One way to commit record before calling report: If Me.Dirty Then Me.Dirty = False

If focus is on the new record, it must first be committed to table so data is available. Reference field in table and control on form. DoCmd.OpenReport "your report name", acViewPreview, , "date field name=#" & Me.controlname & "#"

I have never used FilterName argument. I use WhereCondition argument. Something like: DoCmd.OpenReport "Sales Report", acViewPreview, , "ID=" & Me.tbxID Or use report Filter and FilterOnLoad properties in design.

It is possible to force a report to print out blank rows. I have done it. One method involves a 'dummy' table with blank records and another uses VBA in report Detail section Print or Format events. Review...

I tried that and it did not work, even got error message so figured that was not the box. I have closed and reopened database. Trying to link table and again it does not show. And again I confirmed in Windows Explorer the file is there. Oh wait, have to click Open button then it shows and can...

Exactly which "file box" do you mean? I am navigating from External Data Wizard and I don't see where I can enter *.*. However, I tried Wizard again and now I see the file. Odd I didn't see it before. I had already run the Documenter. Either way, same output.

I tried setting link to the accdu file but External Data Wizard does not show this file extension so the file does not show. I did confirm the file exists. I used IN with the SQL and saved this query object. SELECT * FROM doc_tblObjects IN...

My suggested modification works for me. Don't use Rnd() in the SELECT clause, only in ORDER BY. I tested the SQL in query object as well as VBA recordset.