Search results

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

Well, when you add a combobox in access, you can actually use a wizard to get the data you want. But yes for the second one you need a little knowledge of sql and vba.

Since you asked for a demo : http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=64492&stc=1&d=1479292287 In the file you have a very limited database. And a form who show you how the combobox is working. When you select a country, it will show you all the visa's from that...

I would give you examples with fields of your database. But what do you already have as database ? Can we get a demo version of what you have ?

To populate a combobox you just need to put the query in the Row source and set the Row source type to table/query. A list box just show all the data. The combo box you see only the selected data. You can pick a new one with a dropdown menu. The listbox doesn't have a dropdown menu.

I guess you already have a table for the country and a table for the different categories. All you need is a intermediate table who store all the possible combinations. Then you can use that to make a query to populate your drop-down list.

Can you tell us how you determine the performance of a technician ? This will help if you need just a boolean or different table. Is the performance based on previous projects ?

I would just make a table with the project information. Then in the table of the technicians i add a field project_ID. So that i can pick one or more technicians for 1 project. That allows you to get projects that are not linked to any technicians and select the correct technician based on your...

Personally I'm not very fond of the check all the field one by one. What can happen is that if the user don't fill 2 field he will get 2 messages. First one will tell him to fill the first field. And second one will tell him to fill the second field. giving the user 1 message box with all the...

Well what you try to do is if field1 or field2 is empty, display a message then check if there was some kind of error. Since there are no errors, your code will just go to the gotorecord and start a new record. To fix that, you just need a Exit Sub right after the message box is displayed.

Did you already tried something ? Or do you want us to give you a working solution that meets all your requirements ? I would start by making a diagram with all the tables/enums. Once you have a basic layout of the database, check if you can normalize it. Once that is all done, you can start...