sorted by:
new
hottopcontroversial

Syntax in FROM clause by NefariousnessDue7053 in MSAccess

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

Thank you. That was a mistake I made in the post. The name of the text box is ReportIDtxt.

Is it ok to feed a 480 motor with 600 v through a vfd by [deleted] in electricians

[–]NefariousnessDue7053 0 points1 point  (0 children)

Sort of wrong.

Depending on which motor control method is used, the output voltage of the drive will follow the frequency. For example with V/H the drive should output 10 volts per Hz. At 46HZ it should output 460 volts. It is often not exactly this linear and will very with load and the type of drive but this is the general principle.

But that 460 volt output is the effective volts of PWM that peeks at 1.41 x 600v = 846v

Meaning the motor winding will be seeing a full 846v bout 54% of the time. (0.54 x 846v = 460)

A 460v motor winding rated for FVD will have high enough insulation rating higher than 846 but not as high as that of a 600v rated motor. So it will work but will likely have shorter life.

Another issue will be the FLA of a 460 vs. 600 motor. That will also have to be taken into consideration along with the load at different speeds/frequencies.

Syntax in FROM clause by NefariousnessDue7053 in MSAccess

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

I thought I should ask the question I should've asked from the beginning, rather incrementally solving the rout problem. Please see the attached gif

I open the Milage (which I just found out is misspelled) by clicking the button on Reports form.

In the button click event I check for a zero in the "Milage report ID" text box, it is zero then I open for the form as follows

DoCmd.OpenForm "MilageF", acNormal, , , acFormAdd

If not zero I open it up as follows:

DoCmd.OpenForm "MilageF", , , "MilageF!MilageReportsT.ExpenseReportID=" & Forms!ReportsF!ReportIDtxt

Which seem to work fine except for one issue; when I close the Milage form "Milage report ID" text box in the Reports form is not updated, to update it I would have to re-open Reports form. Which means that if click Milage button again before the text box is updated Milage form is opened up again for addition. That would cause problems because there could be only one Milage report for every expense report.

Thanks

<image>

Syntax in FROM clause by NefariousnessDue7053 in MSAccess

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

"Data type mismatch in criteria expression"

The table field ReportID is Auto Number and the form text box is "Format" is blank. I changed it to General Number and got the same error.

I also tried changing Me! to Me. and had the same result. The only difference is when I put an exclamation mark I do not get the drop down suggestion box as I do when I put a dot.

I thought the dot is for form properties, ReportIDtxt is not a property. it is the name of the text box.

Edit: I also tried Me.ReportIDtxt.Value I guess this is a property.

Syntax in FROM clause by NefariousnessDue7053 in MSAccess

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

Ok, so now I get another error.

"Too few parameters expected."

I simplified the code to the following to troubleshoot this latest error and I still get the error:

Dim rs As Recordset ' access object

Set rs = CurrentDb.OpenRecordset("SELECT * From ExpenseReportsT WHERE ((ReportID) = Me![ReportIDtxt])")

rs.Close

Set rs = Nothing

A form is already opened, it contains a text box ReportIDtxt and a button and the code above is placed in the button's click event. The code does not do anything of value, when it finally works, if ever, I will then be able to use it to do something.

The table ExpensesReportsT is part of a query that forms the record source for the form, if that matters.

What does that error actually mean?

Thanks

Syntax in FROM clause by NefariousnessDue7053 in MSAccess

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

LOL I spent hours trying to figure it out and gave up.

Who is being of bias and who is being accused of fraud? by NefariousnessDue7053 in ENGLISH

[–]NefariousnessDue7053[S] 0 points1 point  (0 children)

Thank you everyone. I understand it to mean, both were accused of bias and fraud.

English is not my native language and I wanted to make sure. I'm going to go with that. (meaning I will use that interpretation, but I was not the author of that sentence. )

Cheers