Search results

All the other continuous forms in my DB work as expected with the exception of one which is defaulting to single form on opening. The form opens from a click event that uses the following VBA, is there anything I can add to the VBA to force it to open as continuous form? DoCmd.OpenForm...

The problem is that the user should not be able to use the product without registering first, I want to keep displaying the splash form until the activation key is entered by the user (basically annoy the user and not let them open any forms unless the product is activated). The login form in my...

That's correct, the file is saving the redeemed key, if I remove the key from the file, I would like the splash screen to appear to the user asking them to renew...but for this I need some programming which saves the key to a specified table, if the key in the table does not match the one in the...

Hey, Thanks, it works well. I do however need your help with the following: - I want to keep displaying the splash form until the activation key is entered by the user (basically annoy the user and not let them open anything unless the product is activated). - I need a check every time the...

Thanks Gasman but it returns null values.

Just one more Q: How do I concat a second condition which is a text field [GradingSystem_] in the query to lookup the field [GradingSystem] in the lookup table. I currently have: however, it is only returning one result for all lookup values.

Hi, Thank you! I set both fields to fixed to 0 decimal places also rounded the percentage field to 0 decimal places and it seems to have fixed the problem. Thank you!

The function is on a query that has a calculated field, looking up a value from the table tbl_att_grade. I am getting values but not all..some missing although they exist in the lookup table.

Not sure why it is returing some values but not others when they clearly exist in the table?:banghead: Expr1: DLookUp("[Grade]","tbl_grade","[A_Score] = " & [Percentage]) Percentage is a calculated field.

Yes Please. Thank you so much.

This looks great, however, not familiar with PHP.

Hi, I want to allocate License keys to users, I want to achieve the concept where I store a license key in a text file on a webserver. Every time the user opens the database, a HTTP response checks the license key to see if it valid. Has anyone created anything like this...or if anyone can...

Hi, I need a query that takes a score as an input, compares the score with the different range values and returns the level (L1, L2, L3) I am not sure how to achieve a VLOOKUP type function. Any advice so that I dont have to type every single value for each range.

My form only displays the relevant fields for the user. The query has many calculated fields which are not needed by the user. I want the user to export these visible fields to an excel document which they can import into their own system. Currently, the excel document displays all the query...

Hi, Can anyone help me modify this VBA to exclude or only include certain fields from a form for an excel export: DoCmd.OutputTo acOutputForm, "Frm_Reports", acFormatXLSX, "test123.xlsx", True

The textboxes were unbound, thank you, problem fixed.

I need help with two issues: 1) I have a tabular form which has a list box and a textbox. The textbox concats values from the listbox. When I scroll down to the next record, the listbox and textbox shows the values from the previous record and these values are replicated to all records. I...

Can we not reference column numbers in this code? Private Sub Command4_Click() Dim v As Variant, s As String With Me.List0 For Each v In .ItemsSelected s = s & .ItemData(v) & ", " Next End With s = Left(s, Len(s) - 2) Me.Text2 = s...

How do I reference the third column in the listbox to concatenate?

This is my first time experience with modules, not sure where I have gone wrong, I am sure it is something simple I am getting an error....anyone please help ? File attached.