I have a recipe main form containing a sub form with data sourced from a table called “TRecipeID” with following fields.
recipeID
RecipeVersion
productID
ProductVersion
WtPct (weight percent as quantity)
The main form has following text, combo boxes, and a calculated variable called DateCodeID (a string).
txt_recipeID
txtRecipeVer
txtBatch (recipe batch quantity)
CboUOM (recipe quantity unit of measure)
With a click of a command button, I am trying to add current data in the subform to the table called "T_Inv_Transaction" as inventory update. The "T_Inv_Transaction" table has the following fields.
recipeID
RecipeVersion
Job_ID
UOM
QTY
ProdID
ProdV
The idea is to update the inventory table with recipe ID and version number equal to the corresponding data in text boxes in current main form ([txt_recipeID] and [txtRecipeVer]).
I adapted codes of similar posts from others and came up with following codes. However, it only return first row of the subform when the command button is clicked. I need some helps to point out what went wrong.
Any help is greatly appreciated. -
Dim strRID As String
-
Dim strRver As Integer
-
Dim DateCodeID As String
-
Dim strQTY As Single
-
Dim strUOM As String
-
Dim strSQL As String
-
-
strQTY = Me.[txtBatch].Value
-
strUOM = Me.[CboUOM].Value
-
strRID = Me.[txt_recipeID]
-
strRver = Me.[txtRecipeVer]
-
-
Dim db As DAO.Database
-
-
strSQL = "INSERT INTO [T_Inv_Transaction] (recipeID, RecipeVersion, Job_ID, UOM, QTY, ProdID, ProdV) " _
-
& "SELECT " & "'" & strRID & "'" & " As recipeID, " & strRver & " As RecipeVersion," & "'" & DateCodeID & "'" & " As JOb_ID, " & "'" & strUOM & "'" & " As UOM, '" & strQTY & "' * WtPct /100 As QTY, productID, ProductVersion " _
-
& "FROM [TRecipeID] WHERE recipeID = " & "'" & Me.[txt_recipeID] & "'" & " AND " & "RecipeVersion = " & Me.[txtRecipeVer]
-
-
Set db = CurrentDb
-
Debug.Print strSQL
-
DBEngine(0)(0).Execute strSQL
-
Can you let me know what do you mean by (Key) and [pk_child] in your last code block? Is Key a function in SQL statement? I am guessing [pk_child] refers to primary key in the table.
Both refer to field names [Key] and [pk_child], if you look carefully the [Key] is enclosed within the () of the field list for the insert; however, I was typing this in by hand and missed the "[]". Access doesn't complain too much about this in this case because the SQL engine interprets words within the () as fields. WITH THAT SAID; however, "Key" is a reserved work and I should have enclosed that within the [].
It works now. It was a mistake in table design. I accidentally assigned a primary key to the Job_ID field in inventory table, so the Insert Into statement cannot insert 2nd row.
Hmm, in the execute method insert the dbFailOnError option zDB.Execute zSQL, dbFailOnError
This should catch errors like this :) and is one of the reasons I use the execute method vs. the docmd.runsql as this error is trappable (and we can get a count of affected records :) )
Thank you for your help. Through this, I learned a lot of vba and SQL skills and SQL troubleshoot techniques from you.
My pleasure.
However, I really must apologize, looking back thru the thread I see where I missed a few things, and assumed some things I shouldn't have, and I could have gotten us there sooner. :(
The two main goals were achieved though: resolving your current issue and helping you to develop some tools that should help you when something like this happens again!
Best Of Luck with your project!
-Z
19 1656 zmbd 5,501
Expert Mod 4TB
Set a variable to the form's recordset Dim zFormsRS as DAO.Recordset Set zFormsRS = Me!zctrl_sfc_child.Form.Recordset
Now you can check to see if there are any records IF zFormsRS.recordcount THEN ...
and if =1 or greater (you don't need a full count, just see if there is at least one) you can either set up the SQL and do a DB.Execute SQL, dbFailOnError or using the add-method to another recordset by looping thru the zFormsRS values.
Not sure how to directly merge a Form's recordset directly to a table - I've usually only needed the primary key values and use those in the related tables as needed. :)
zmbd,
Could you please explain and provide more details? My level of vba is not capable of understanding your method.
Thanks,
Joe
zmbd 5,501
Expert Mod 4TB 1) It's advisable to check that your database is properly normalized and designed: Database Normalization and Table Structures
It does appear to be; however, it's just a good starting point to review the overall design :) . 2) Joe Y, I think you can do this :-)
Let's lay out the logic
+ Need a variable to hold the SQL String
+ Need a variable to point to the current database
+ Need a variable to point to the subform recordset ( post#2)
+ Set the variable for the subform recordset
+ Check for the existence of any records in the subform
+ if there is at least one then ( Also post#2)
set the variable for the current database (line19 of your code)
++ (if not using the INSERT/EXECUTE method)
++ move to the first record( rs.movefirst - syntax) in the subform recordset
++ Do_Until loop (syntax) to step thru the subform's records (rs.movenext)
at each record build your SQL string (basicly line 15 in your OP; however, referring to the form's record source fields see ibid: 3b )
use the execute method (line 21 however, your code is a bit jumbled) until you hit the end of the recordset ( rs.eof)
+++ using the insert/execute method you can check for effected records etc... to see if the insert was successful
+ set the variable for the subform's recordset to nothing
+ set the variable for the current database to nothing 3) There a few issues I have with writing the actual code at this point: a) In OP you first refer to the "main-form" then you refer to a "sub-form" and finally the code you've posted uses the ME.[****] construct - would you verify that ME.[****] is from code in the sub-form and not the main-form and that you are placing the command button on the sub-form and not the main form. b) Lines 8 thru 11 in your post refer to the controls on the form. Are these controls "unbound" or bound to the record-source for the form. Using the recordset method, we will need the actual names of the fields of the record-source of the form. c) if I write the code then you do not benefit from the experience nor will you really understand what it is that the code is doing (i.e. Line19 and then Line21 usually, you need one or the other not both :) ); however, if you attempt to write the code and post back we can help you to perfect the script and you will better understand what is being done.
- there are huge storms where I live right now so I may be without power for the next few days :-( we've already been thru one major storm last night - the trees look like they've been thru a meat-grinder. sad.
Thanks zmbd. I will try and post back the code/results. It will be a while, too.
It appears that you are in Southeastern Asia. I have family members living there and learned that this is a super hurricane. Be safe and best wishes.
zmbd 5,501
Expert Mod 4TB
+ take your time, someone here will be there to light the way.
+ Not S.E.Asia, they have a really bad situation there - hope your family gets thru the mess! I'm in the Midwest-USA, it's prime tornado season for this area :)
Here is the code that I have, so far. I thought this should solve the problem, but apparently not.
When the code is executed, I can actually see the highlight run through each row of sub form. However, it still only insert first row ingredient and quantity (from the sub form) of the recipe to the inventory table.
To clarify questions about my original post, here is detail of the design.
Recipe main form named Recipe includes following Text/Combo boxes requiring users to enter.
txt_recipeID (shows recipe ID as result of recipe selection)
txtRecipeVer (shows recipe version as result of recipe selection)
txtBatch (recipe batch quantity)
CboUOM (recipe quantity unit of measure)
txtProductionDate (production date text box, unbound))
DateCodeID (a string) is a calculated variable based on txtProductionDate and daily auto number to be a Job/Batch ID.
Recipe sub orm (control name Q_Recipe ) includes following fields from Table “TRecipeID”.
recipeID
RecipeVersion
productID
ProductVersion
WtPct (weight percent as quantity)
After execution of the code, I wish to insert every rows in the sub form (basically all ingredients ID, version and qty used in the recipe) to the inventory table “T_Inv_Transaction” with following fields populated.
recipeID
RecipeVersion
Job_ID
UOM
QTY
ProdID
ProdV
I think the problem is the SQL statement, but not sure what went wrong. I used a similar SQL statement for a copy recipe function and it worked just fine (copied every rows of ingredients and qty to a new recipe record) - Dim rsSub As DAO.Recordset
-
Dim intl As Integer
-
Dim strSQL As String
-
Dim rscount As Integer
-
-
Set rsSub = Me!Q_Recipe.Form.Recordset
-
-
rscount = rsSub.RecordCount
-
MsgBox rscount, vbOKOnly
-
-
If rscount < 1 Then
-
-
MsgBox "No Record", vbokaonly
-
Exit Sub
-
Else
-
-
lpct = 1
-
-
With rsSub
-
-
Do While Not .EOF
-
-
MsgBox lpct, vbokayonly 'just to check the loop works
-
-
strSQL = "INSERT INTO [T_Inv_Transaction] (recipeID, RecipeVersion, Job_ID, UOM, QTY, ProdID, ProdV) " _
-
& "SELECT " & "'" & strRID & "'" & " As recipeID, " & strRver & " As RecipeVersion," & "'" & DateCodeID & "'" & " As Job_ID, " & "'" & strUOM & "'" & " As UOM, '" & strQTY & "' * WtPct /100 As QTY, productID, ProductVersion " _
-
& "FROM [TRecipeID] WHERE recipeID = " & "'" & strRID & "'" & " AND " & "RecipeVersion = " & strRver
-
-
dbs.Execute strSQL
-
-
lpct = lpct + 1
-
.MoveNext
-
-
End With
-
-
dbs.Close
-
rsSub.Close
-
-
End If
-
End Sub
zmbd 5,501
Expert Mod 4TB
I agree that the SQL has an issue... more later:
Read thru How to ask "good" questions>Post#2>SectionA You may have to repeat the compile step in Section-A several times as the compiler stops on the very first error encountered.
Line 11: You really Need to test for Record count equal to or greater than one OR for the simultaneous BOF and EOF condition. In either case, the logic should allow you to determine if there are any records. Counts less than 1 shouldn't be possible. In post 2 I show the start of such a test for the record count.
Line 21: you do not show a matching Loop , I really do not know how this code as written would even execute once without the matching Loop .
However, Using the SQL in Line 25-27 along with Line 29 should have done the trick without the need for the loop, it does look a bit strange though, so I would delete line 21. (edit, loop for line21 was omitted by mistake)
SO, how to resolve the SQL issue? What I am thinking here is, in the QUERY EDITOR, write a simple SELECT query that returns the desired records, with the fields "as-is", for one of your recipes - say [RecipeVersion]=2. Make sure that the records returned in the query would be those that have the data you would like to insert into [T_Inv_Transaction]. Post that SQL back to the thread. What I am after is the correct version of the SQL needed and this will also let me see what the table relationships you are using.
I apologize. I must have the Loop line deleted while removing lots of junks from my code before posting (junks such as comment lines and testing message box lines, etc.). Here is the code that it should to be.
I will post back later for SQL editor test and result.
Thanks. -
Dim rsSub As DAO.Recordset
-
Dim intl As Integer
-
Dim strSQL As String
-
Dim rscount As Integer
-
-
Set rsSub = Me!Q_Recipe.Form.Recordset
-
-
rscount = rsSub.RecordCount
-
MsgBox rscount, vbOKOnly
-
-
If rscount < 1 Then
-
-
MsgBox "No Record", vbokaonly
-
Exit Sub
-
Else
-
-
lpct = 1
-
-
With rsSub
-
-
Do While Not .EOF
-
-
MsgBox lpct, vbokayonly 'just to check the loop works
-
-
strSQL = "INSERT INTO [T_Inv_Transaction] (recipeID, RecipeVersion, Job_ID, UOM, QTY, ProdID, ProdV) " _
-
& "SELECT " & "'" & strRID & "'" & " As recipeID, " & strRver & " As RecipeVersion," & "'" & DateCodeID & "'" & " As Job_ID, " & "'" & strUOM & "'" & " As UOM, '" & strQTY & "' * WtPct /100 As QTY, productID, ProductVersion " _
-
& "FROM [TRecipeID] WHERE recipeID = " & "'" & strRID & "'" & " AND " & "RecipeVersion = " & strRver
-
-
dbs.Execute strSQL
-
-
lpct = lpct + 1
-
.MoveNext
-
-
Loop
-
-
End With
-
-
dbs.Close
-
rsSub.Close
-
-
End If
-
End Sub
-
-
The SQL below did return all records of fields associated to recipe ID = “WIP 94639” and recipe version = 3. - SELECT * FROM TRecipeID
-
WHERE recipeID = "WIP 94639"
-
AND RecipeVersion = 3;
There is no direct relation of the two tables “TRecipeID” (the source of data) and “T_Inv_Transaction” (insert into table).
Table design: -
Table “TRecipeID”:
-
recipeID
-
RecipeVersion
-
productID
-
ProductVersion
-
Recipe_UOM (this UOM is not intended to be used in the inventory table. Instead the UOM from main form chosen by user is supposed to be inserted in to the inventory table)
-
WtPct
-
-
Table “T_Inv_Transaction”:
-
recipeID
-
RecipeVersion
-
Job_ID (a calculated variable based on a couple text/combo boxes in the main form)
-
UOM (data from a text box from the main form)
-
QTY (calculated number - WtPct from TRecipeID table multiplied data of a match size quantity textbox in the main form)
-
ProdID
-
ProdV
-
This SQL in the SQL editor also produce correct results (all ingredients/rows). - INSERT INTO [T_Inv_Transaction]
-
(recipeID, RecipeVersion, Job_ID
-
, UOM, QTY, ProdID, ProdV)
-
SELECT "WIP 94639" As recipeID,
-
3 As RecipeVersion,
-
"201607140001" As Job_ID,
-
"LB" As UOM,
-
'1200' * WtPct /100 As QTY
-
, productID, ProductVersion
-
FROM [TRecipeID]
-
WHERE recipeID = "WIP 94639"
-
AND RecipeVersion = 3;
but this SQL in the vba only produce one row as result. - strSQL = "INSERT INTO [T_Inv_Transaction]
-
(recipeID, RecipeVersion, Job_ID
-
, UOM, QTY, ProdID, ProdV)" _
-
& "SELECT " & "'" & strRID & "'" & " As recipeID, " &
-
strRver & " As RecipeVersion," &
-
"'" & DateCodeID & "'" & " As Job_ID, " &
-
"'" & strUOM & "'" & " As UOM, '" &
-
strQTY & "' * WtPct /100 As QTY
-
, productID, ProductVersion " _
-
& "FROM [TRecipeID] WHERE recipeID = " &
-
"'" & strRID & "'" & " AND " &
-
"RecipeVersion = " & strRver
zmbd 5,501
Expert Mod 4TB
In the VBA insert a DEBUG.Print strSQL
right after the line that builds the strSQL
Run the code
<ctrl><G> to open the immediate-pane
The resolved strSQL should be printed in this pane. Copy and paste it back to this thread so that we can see what is actually being passed to the Execute method.
The resolved strSQL is this. It seemed that lack of proper codes around WtPct is causing the problem? - INSERT INTO [T_Inv_Transaction]
-
(recipeID, RecipeVersion, Job_ID
-
, UOM, QTY, ProdID, ProdV)
-
SELECT 'WIP 94639' As recipeID
-
, 3 As RecipeVersion
-
,'201607190002' As Job_ID
-
, 'LB' As UOM
-
, '1200' * WtPct /100 As QTY
-
, productID, ProductVersion
-
FROM [TRecipeID]
-
WHERE recipeID = 'WIP 94639'
-
AND RecipeVersion = 3
zmbd 5,501
Expert Mod 4TB
++ The resolved string has a lot of issues with it, in fact, it doesn't even look like a proper SQL for an INSERT action query. None of the information there really matches any fields nor other values mentioned in the other posts for such a query. Sorry, I should have caught that back in your first post :(
To trouble shoot SQLs what you can do is:
> Open the Query editor
> Do NOT add any tables, cancel the dialog
> Switch to SQL view
> Cut and paste the Resolved string in to the SQL editor window, replacing any other text
> Attempt to run the SQL.
I am suspecting that if you do this with the resolved string posted here, you're going to receive a few errors. :)
Instead what it looks like you needed for the resolved string is - INSERT INTO [T_Inv_Transaction]
-
(recipeID, RecipeVersion, Job_ID
-
, UOM, QTY, ProdID, ProdV)
-
VALUES ( 'WIP 94639', 3 -
,'201607190002', 'LB'
-
, '1200'
-
, productID, ProductVersion
);
Then loop thru the record set pulling the values from the current record on the form. I would like to use the simpler SQL approach; however, you appear to have a few calculated values - strRID == recipeID
-
strRver == RecipeVersion
-
DateCodeID == Job_ID
-
strUOM == UOM
-
(strQTY * WtPct /100) == QTY
-
Where strQTY == (form value)
-
WtPct == (form value)
-
productID == (form value)
-
ProductVersion == (form value)
So, let me make amends (at least partially) for missing the malformed SQL in the first post. Going back to the above code block we have the following for our SQL string ( BEST GUESS HERE!): - strSQL = "INSERT INTO [T_Inv_Transaction]" & _
-
" (recipeID, RecipeVersion, Job_ID" & _
-
", UOM, QTY, ProdID, ProdV)" & _
-
" VALUES ('" & strRID & _
-
"', '" & strRver & _
-
"', '" & DateCodeID & _
-
"', '" & strUOM & _
-
"', '" & (strQTY * WtPct /100) & _
-
"', " & productID & _
-
", " & ProductVersion & ");"
What I am guessing at here are: strRID, recipeID, strRver, RecipeVersion, dateCodeID, Job_ID, strUOM, strQTY, WtPct, productID, and ProductVersion.
However, using some dummy values and the above string, my resolved string is now: - INSERT INTO [T_Inv_Transaction]
-
(recipeID, RecipeVersion, Job_ID
-
, UOM, QTY, ProdID, ProdV)
-
VALUES ('AA', 'CC', 'YYYYMMDD'
-
, 'FF', '1232.1', FF, GG);
Provided the variables are properly defined (I don't see that in your code), AND the quotes are correct for the text fields, ((extra quotes will error for numeric fields!)), this string should work.
Thanks zmbd.
I tried the SQL code in the vba, but got SQL syntax error message and the resolved string is this. -
INSERT INTO [T_Inv_Transaction] (recipeID, RecipeVersion, Job_ID, UOM, QTY, ProdID, ProdV) VALUES ('WIP 94639', '3', '201607150001', 'LB', '0', , );
-
I have some clarifications about the variables and fields: -
strRID == recipeID (from the main form)
-
strRver == RecipeVersion (from the main form)
-
DateCodeID == Job_ID (Calculated auto number values based on date chosen and dim as text)
-
strUOM == UOM (from the main form)
-
(strQTY * WtPct /100) == QTY
-
Where strQTY == (form value)
-
WtPct == (field value from Table “TRecipeID”.
-
This is where ingredient percentage stored for each recipe)
-
-
productID ==(field value from Table “TRecipeID”. Ingredient ID of every recipe)
-
-
ProductVersion == (field value from Table “TRecipeID”). Ingredient version of every recipe
-
Because WtPct, productID, and ProductVersion are fileds from the source table “TRecipeID”, I think a “Select” and “From” operator are needed in the SQL string. Otherwise Access does not know where to pull these data from and insert into the inventory table.
I have modified my SQL string to this (I think this makes more sense with proper SQL language). Still, it only insert first row of my recipe data in to the inventory table. -
strSQL = "INSERT INTO [T_Inv_Transaction] (recipeID, RecipeVersion, Job_ID, UOM, QTY, ProdID, ProdV) " _
-
& "SELECT '" & [strRID] & "' As recipeID, " & strRver & " As RecipeVersion, '" & DateCodeID & "' As Job_ID, '" & strUOM & "' As UOM, " & strQTY & " * (WtPct /100) As QTY, [productID], ProductVersion " _
-
& "FROM [TRecipeID] WHERE [recipeID] = '" & [strRID] & "' AND RecipeVersion = " & strRver & " ;"
-
zmbd 5,501
Expert Mod 4TB
+ The error might have occurred due to the "empty" values in the VALUE clause of the SQL. Most likely due to my guesses about where your data was being pulled from.
+ DateCodeID == Job_ID
(Calculated auto number values based on date chosen and dim as text)
Not sure what you mean by a "calculated AutoNumber"
+ Because you are pulling from both the table and the form, yes, most likely we'll need the table name ( SELECT...FROM ) in the string.
> this does have me a bit curious, say I use something like: - s = "INSERT INTO [t_CurrentMap] (Key)
-
SELECT ('A;M;x' & [t_Child]![pk_child])
-
AS KEY
-
FROM [t_Child]
-
WHERE([t_Child]![pk_child]>=5);"
and [pk_child]>=5 has 10 records, then all ten records are inserted with "A;M;x5","A;M;x6"..."A;M;x15" in the [Key] field (just tried it to make sure) so the loop might not be needed unless something is changing between the record values in "rsSUB" that would be needed for either the criteria or the calculations - so:
+ Going back the code in Post#9 Just before you go into the loop let's make sure that you are on the first record of "rsSub" by inserting rsSub.MoveFirst - line 16 looks like a good spot.
Insert a STOP at line 18 and run your code. Once the VBA editor opens, you can use the [F8] key to step thru your code. We need to see how many times your loop is executing.
What I noticed here is that we do not have any constructs such as [rsSub]![fieldname] in your SQL statement nor do I see anywhere where the string values are altered (at least not in the code in post#9, I do see where they were set in Post#1; I am really off my game on this... too many irons in the fire :-( ) - so as you go thru the loop each time, the Debug.print strSQL (hopefully it's still there, of not re-insert it) should be sending the resolved string to the immediate window (<ctrl><g>) compare the resolved strings as you pass thru the loop. Are these changing? Take a look at the WHERE clause in the resolved string - is there more than one record in [TRecipeID] that will match this criteria with each version of the string?
zmbd,
DateCodeID is a a variable: Today's date + 4 digit number (starting from 0001). So the format is like 201607150001. Other part of my code not shown in this sub checks a JOB_ID table to look for max number of the date and incrementally adding 1 in the last four digit. Sorry for not being specific.
Can you let me know what do you mean by (Key) and [pk_child] in your last code block? Is Key a function in SQL statement? I am guessing [pk_child] refers to primary key in the table.
However, the two tables (select from and insert to) do not have primary key. Will your last code work with no primary key in either table?
zmbd,
It works now. It was a mistake in table design. I accidentally assigned a primary key to the Job_ID field in inventory table, so the Insert Into statement cannot insert 2nd row.
I found this from the last two posts that you made me to re-exam the primary key in the two tables.
Thank you for your help. Through this, I learned a lot of vba and SQL skills and SQL troubleshoot techniques from you.
zmbd 5,501
Expert Mod 4TB
Can you let me know what do you mean by (Key) and [pk_child] in your last code block? Is Key a function in SQL statement? I am guessing [pk_child] refers to primary key in the table.
Both refer to field names [Key] and [pk_child], if you look carefully the [Key] is enclosed within the () of the field list for the insert; however, I was typing this in by hand and missed the "[]". Access doesn't complain too much about this in this case because the SQL engine interprets words within the () as fields. WITH THAT SAID; however, "Key" is a reserved work and I should have enclosed that within the [].
It works now. It was a mistake in table design. I accidentally assigned a primary key to the Job_ID field in inventory table, so the Insert Into statement cannot insert 2nd row.
Hmm, in the execute method insert the dbFailOnError option zDB.Execute zSQL, dbFailOnError
This should catch errors like this :) and is one of the reasons I use the execute method vs. the docmd.runsql as this error is trappable (and we can get a count of affected records :) )
Thank you for your help. Through this, I learned a lot of vba and SQL skills and SQL troubleshoot techniques from you.
My pleasure.
However, I really must apologize, looking back thru the thread I see where I missed a few things, and assumed some things I shouldn't have, and I could have gotten us there sooner. :(
The two main goals were achieved though: resolving your current issue and helping you to develop some tools that should help you when something like this happens again!
Best Of Luck with your project!
-Z
zmbd, Your helps are greatly appreciated!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Roy Padgett |
last post by:
I have a combo box where users select the customer name and can either
go to the customer's info or open a list of the customer's orders.
The RowSource for the combo box was a simple pass-through...
|
by: Bob |
last post by:
I just started playing with the XML extensions of the CRL and have a question and have not seen how why what I have here is happening. Now I do know my XML is not complete and the file layout we are...
|
by: Tim Graichen |
last post by:
Hi!
I have a subform (ShedTableSubForm) at the bottom of my MAIN form. I would
like to do two things.
1) preview on screen a report (ShedReport) of the subform data the record
currently...
|
by: Don Seckler |
last post by:
I am building an application to track the distribution and returns of
copies of magazines.
Copies of a magazine that are unsold are returned by the retailer to
the wholesaler. They are...
|
by: Shibu |
last post by:
Hi,
I have a situation where I need to convert business objects to a flat table.
The reverse is also required. I am using c# and
Oracle ODP. I am looking for an easier method to do the below...
|
by: Neil |
last post by:
Hello Everyone..
I wrote a function called "totalsales" for a short business program I
wrote, and I can't keep the decimal point aligned in the colums in the
printf output statement. The data...
|
by: mforema |
last post by:
Hi everybody,
I need to create a query that will search based on keywords and major categories. My tables are set-up as follows:
tblLiteratureArticles:
Abbreviation(FK)
ArticleID(PK)
Author...
|
by: drwigginton |
last post by:
I have created several bar charts in MS Access using query results to provide the data for the chart. I added data tables to the charts to show the actual values. My problem is that one of the fields...
|
by: troy_lee |
last post by:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is...
|
by: John James |
last post by:
I need to create a new Access DB based on one already existing...Hence, I am attempting to copy the db struture and not the data; It's a yearly db I need to track/create. I looked on this site and...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |