Search results

total cost, if stored, is what data type

Ok I know ... the silly thing: strsqlA4 = "insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, ""#"" && "F1" && ""#"" , F3, Replace(F4,""."","",""), Replace(F5,""."","",""), F6, Replace(F7,""."","",""), F8 from AntroImpo

A customer can have one or more lease agreements A truck can only belong to one lease agreeement at a time but can be re-leased later?

Proper way of doing SQL in code is described here: http://www.baldyweb.com/immediatewindow.htm Follow that routine and it will save you lots of grief. Like 'smoething' is wasted and could be an equal sign. If you mean a potential subset of the string then you need a "*" so Like '*' &...

debug.print sql, I will not fight blind

Look at my latest corrected version please. As to your decimal numbers: I think that will be wrong too. SQL requires " ." as decimal separator, even if you locally use "," to say 1,5 =(1½)

Sorry, it should be (I removed superfluous "): strsqlA4 = "insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, #" & F1 & "#, F3, Replace(F4,""."","",""), Replace(F5,""."","",""), F6, Replace(F7,""."","",""), F8 from AntroImpo

IF F1 is text then "#" & F1 & "#" should pass the text wrapped in #, which is what is required for SQL. Please show an SQL string. debug.print strsqlA4

A word of advice: do not let the internship become Access-focused. An "internship" on many occasions means "Oh hallo, so you are our new free slave obliged to do whatever crap we come up with and have not bothered to do ourselves?" Access works on huge majority of IT-departments like a red rag...

strsqlA4 = "insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, "#" & F1 & "#", F3, Replace(F4,""."","",""), Replace(F5,""."","",""), F6, Replace(F7,""."","",""), F8 from AntroImpo since your date is formatted correctly for...

DoCmd.Echo False after all calcs should be followed by DoCmd.Echo True Which should update entire screen, incl. the status thingy. Unfortunately, it is not always jump/flash-free, that depends among other things on what is on the form. I have a case where actually switching Echo off makes it...

Good of you to provide feedback.

No. It's the view of essentially all who volunteer their knowledge here. SInce you did not understand what it is about I'll try to make that clear: "WE DO NOT LIKE TO SEE OUR EFFORT WASTED". So as CJ_London said: double post and wave goodbye to any help.

"Auto number not incrementing correctly" What is "correctly" ? You seem to have an idea about sequential incrementing autnumbers, but that has never been promised nor guaranteed, not in Access. You are only quaranteed uniqueness. Google access autonumbers

Just to illustrate (when the precise scope is seldom known at the outset), check out the figures that show the factor (and the ensuing uncertainty) to multiply the final true budget, depending on how far you are. I can highly recommend Construx (am not associated with them in any way) -...

I'm with JHB on this: But the pricing issue is not related what it costs to make the thing, but what it is worth to the client. Remember that the client will not sign-off on thew deal unless they feel it is a worthwhile one. The price can be fixed (customers love that) but the amount of...

You need to clarify your idea. Data is stored in a table. A form is used to view or manipulate data, not to store it. The essence of a database is a good data structure, forms are of slightly lesser importace, despite the forms being visible to user and tables not. Your post is rather...

#12 Doing everything using recordsets would probably bang your head against number of simultaneous something-or-other (don't quite remember what, but it's that thing at 70,000 as default, or thereabouts.) I suspect the culprit in the OP's case was attempting to do everything in one subroutine...

Must have uploaded wrong copy -sorry folks:

@Libre: Quite. Forgot we are not dealing with a grown-up.