Search results

So regardless of the design of the database, did you get the query working ?

Do you have any message error ? Also i guess BespokeID is a primary key, so there shouldn't be any record in your table where it is null. The where is pretty useless in that case.

I agree on that point. His database is not normalised. But when a working query he can tweak the database and modify the sql to fit his new design.

You can just format the decimal field. Format(Me.[Amount],"Standard") But if the amount is not a decimal then you still get errors.

The line must be this : Debug.print "INSERT INTO tblTransactions ([Account1ID], [Account2ID], [TransactionDate], [TransactionType], [TransactionCategory], [Amount])" & _ " VALUES ( " & Me.[Account2ID] & " , " & Me.[Account1ID] & " , #" & Format(Me.[TransactionDate], "mm/dd/yyyy") & "# , '" &...

Windows 7 and Access 2016. I cannot click on frm1. It is a strange behavior... Or maybe a windows 10 thing. Maybe they keep track of the number of modal windows and descide only 1 modal view can be displayed on screen and make the frm2 default non modal.

Well yes you can add a table to store the history. But that will not be a function table in that case. It will just be a table with an unique ID and 2 FK : WidowID and LegaleeID. He just wants a list of other Widow's that have currently that legalee. In my query I excluded the widow that the...

Change the query WhichOthers with this : SELECT Widow.WidowName, Widow.WidowLegatee, Legatee.LegateeName FROM Widow left join Legatee On Widow.WidowLegatee = Legatee.LegateeID WHERE (((Widow.WidowLegatee)=[Forms]![Widow]![cmbWidowLegatee]) AND ((Widow.WidowId)<>[Forms]![Widow]![WidowID])); You...

Yes sorry. That is correct. So for each score you have a header and a record. But I don't see why you need headers since you want to display the score in one table. Why not just use the query as datasource ? Example : Set WordDoc = WordApp.Documents.Open(strTemplatePath & "Health Check...

I am confused now. You show code from an other topic (the one were scores needs to be displayed in word) And here it is the answer of each question. So what do you want here ? scores or answers ?

But your complete code is not correct... you cannot get variables by using "score" & i. Have you tried to fix that already ?

Yes you will have to create a word document and use the mail merge thing : Just start the wizard and when you need to select a file, select the access database. There you will be able to select your data and use the fields to create the table. (If you have trouble just create a A4 label.)

I see. The templates I uses are made so i can display at the bottom of access a counter. Like "processing file x of y" If you want that, you must first move to the last record to get the correct value in "RecordCount". But again, it is a matter of preferences i guess. You can also just test if...

So it is save to say that using the 'IsMissing' in this case was just for education purpose only. In a real situation you will never do something like this. You can check for optional variables but still I think this option is beter : Function MakeIceCream1(Optional CocoaToBeAdded As Variant =...

Is it possible to show us all the code ? My guess is that it in the code that call's the 'MakeIceCream' the parameter can be null. Since CocoaToBeAdded is a variant it can be anything (a string, or number or date).

If you reset Me.test in each case, I don't see why you need to check it in each case. You know that once you enter in a case, the other ones are skipped. So if you set Me.test= null at the end of the Select. The number will always be null the next time the function is called. Or am I missing...

I like to first check on that EOF or BOF before starting the loop : With CurrentDb.OpenRecordset("SELECT * FROM qryQAMatrix WHERE QAID=" & Me.txtQAID) If Not .BOF And Not .EOF Then .MoveFirst Do While Not .EOF headers = headers & "Score" & i & vbTab record = record &...

Have you downloaded the file ? You can see that there is some vba between the combobox of country to update the visa combobox. So yes you will have to learn a minimum of VBA. That is why some people here asked you to see the videos ...

Well you will need to open the file and see where it is used. This can be a background of a form or an icon on a button. So you will have to find it with some patience. Maybe the database uses a style that doesn't exist anymore. (If you want you can post the database here and I can check with...

I think that since it was an old access file, the file tries to find that GLOBE.WMF Maybe with converting the database it will work fine : https://support.office.com/en-us/article/Convert-a-database-to-the-accdb-file-format-098DDD31-5F84-4E89-8F44-DB0CF7C11ACD