Search results

I've catched dcount with msgbox and always get 0, with or without data. It seems that it doesn't read anything in the table. Table's structure contains: CASNumber: short text Completed field: short text (accepted values as text, Yes/No) Running the query, i get only the records containing data...

[Completed] is a textbox which you have to write "yes" or "no" I will change it to checkbox and follow your directions! Thanks!!!!!!

Dear friends, i have the following code, in a save button: Private Sub cmdSave_Click() Dim lcount As Integer If Me.Dirty Then Me.Dirty = False lcount = DCount("casnumber", "tblCLPDGRPictogrammes", "[casnumber]=" & Me.CASNumber & " And [completed]='Yes'") If lcount <> 0 Then Me.Text1134 =...

Dear friends, any idea how to use ucase in vba and make an excel column data upppercase? I've used the following commands under with, but i always get errors. Ucase.columns("A:A") .columns.Ucase("A:A") I think its syntax error returning by excel because i don't get any compile errors...

Thanks! It's working!

Dear friends, i've got the following code for exporting a query to a workbook. I would like to have another sheet with informations. The problem is that the book is always recreated and if i use it as a template, all the sheets are always deleted. Any ideas? I'd like to have 2 sheets, 1 the...

Hello friends, i have the following syntax in my query: WHERE (((tblMaintenanceActions.FinishedDate) Between Date() And Date()+30) AND ((tblMaintenanceActions.Completed)=False)) OR (((tblMaintenanceActions.AApproval)=False)) OR (((tblMaintenanceActions.BApproval)=False)); I want to view...

Thank you all for the help! I've used split function and it's working perfectly! :)

Hello everybody! Could you please assist me? I've got a field which contains 1 or 2 words. I would like to get the following: - If there's 1 word, the first 3 letters (its already ok with Left function) - if there are 2 words, the first 2 letters from the first word and the 1st from the...

Thanks both of you!

Hello everybody! Dear friends, i've got a database for incoming samples which works as following: -A unique number and further information are assigned to every sample. -An automessage is generating (which contains an rtf report with sample's information and a request analysis file as excel)...

Thanks guys! pbaldy's advice is working fine!

Hello dear friends, is it possible into a table containing numbers from 1 to 100, to run a query and find if there's any missing numbers? Thank you in advance! Costas

arnelgp It worked! Thank you very much!

Thank you arnelgp! I've tried the following (i can't find a way to reconstruct the table...) I've created a query (qryTest) where data are linked. Problem so far is that i've got dublicated each record (2 products, 2 times each one). Trying that, i'm using the query (and...

It's the same problem like the following: https://access-programmers.co.uk/forums/showthread.php?t=301160 I've created a query for each table and changed the report's/subreport's source data but without success. I've also tried with the code described in the attached file in the post but also...

It looks like a mess! :P Sorry for complicating you! Please let me give one more try and i'll add the code in the end. The form contains 4 tabs.(main form contains 2 fields, Record ID and SDS_ID) The 1st 3 tabs contains subforms, which data are from a query 4th tab, is a table. In...

I'm sorry, i didn't mentioned that! All sections are linked under the same product ID. Record sources: Main product: Record ID (autonumber, key) Product ID Name etc SubProduct Record ID (autonumber, key) Product Code Name etc Section 1 Record ID Product ID Name (Combo from SubProduct...

Hello dear friends, my problem is the following: I've a form which contains 4 tabs. In the 1st tab there's a subform where you can add items form a list* This tab is called section 1. All the other tabs contain record fields (sections 2,3,4) *items list table contains many data, i let the...

Thank you all (one more time :)) for the help! I kept Mark_'s solution! Best regards, Costas