Search results

Is txtID a text field or a numeric field? Is Procedure Name a text field or numeric field? What are you really trying to lookup? Do you have example of the data?

Yes, just use the replace function in an update query. The example I gave replaces "https" with "http". The think is if you simply try to get rid of the "s" then you will lose the "s" from other parts of your text also.

The replace function will replace text in a string with some other text: Replace("http","https",[myLink])

looks like you want to use the second dlookup as part of the string criteria for the first lookup? Is that right? In which case, try: timevalproc = DLookup("[Haircut Time]", "tblEmployee", "[Employee ID] = '" & [txtID] & Dlookup("[Procedure Name]","tblProcedure", "[Procedure Name]= '" &...

The solution you provided is a datasheet form as the main form and then a continuous form as the subform. vb.net does not have sub forms as such. If you have the budget then you could use a 3rd party tool such as flexgrid (approx $900 for the activex version) which gives you mind-blowing...

Thanks for the feedback. I've corrected the arrows (doh!). I've also added some more comments. I'll try and write a better overview of how it all fits together particularly the part that each of the three classes plays. I suspect the op needs to go with one of the other solutions. They all...

I did an example of a "data grid" here. I used it to show data in a tabular row/column fashion rather than just row. It work like IssKint and sneuberg describe in post 2 & 3. Due to the nature of the design you can pretty much code whatever you want to do with the "cells". You can get round...

You can try summing the value fields and do Max on the remarks field.

I posted an example here, post #7 which might be of interest. Also look futher down the same thread at a post by MarkK (post #13). You will need good VBA knowledge.

Here's another alternative to arnelgp's perfectly good answer =SUM(IF(FREQUENCY(A1:A5,A1:A5)>0,1)) Source: https://support.office.com/en-gb/article/Count-unique-values-among-duplicates-7889942d-824e-4469-893c-191d1efde950

How do you get the results from the supplied data? Take 1111111 for example. The difference in months between each date is 18, 23 and 16 months respectively. So the average is around 19months. How do you get to 5.5? As an aside, you don't need to calculate the difference for each order. You...

.value isn't necessarily the current contents of a control. So what happens if you change .value to .text? Also, what other code do you have? Can you post it.

Change CJ_Londons query to Like instead of not like. This will give the phrases that DO match. Then use this as a sub query on the phrases table to exclude the matched list i.e a left join where no match.

You can also refer to the page names directly rather than via the tab control reference once you've named them sensibly. So to reference the page called pgUpdates as: me.pgUpdates.Visible=True You can do this because each page on a tab is also a member of the form's control collection. Hence...

Afaik, Access has no knowledge of VBA constants. So if you try to use acLast in the form designer screens then Access will assume you are referring to a field name.

I'm using Office 365 and Access 2016 any noticeable difference from previous versions. I can certainly store millions of records in normal accdb files. Not had any issues with any code and I have plenty of that.

Import the data to a temporary table in Access. Then write 5 (or is it 4) append queries to copy each column to the target table.

Following on from The_Doc_Man, a call centre database is a tricky one to pin down. If you take the example of an ordering database, these are normally quite easy to design because there is a clearly define paper system and the database is put in place to replicate. With a call centre it is...

Get rid of the single quotes from your expression. Dates don't require quotes, only hashes (#)

Why not have an agreement in place where you simply hand over the source and documentation to your respective customers. You're going to have to have your databases well documented in any case. The point is, when the time comes you need to be in a position where you can hand over with the...