Search results

Hi everyone! I have an issue: I get data from an online form via excel (linked table), which i append in my main table in access. Each record has a field with an attachment, which i get as text/hyperlink in my linked table. Is there a way to download the file and save it in a local folder...

Dear friends, i've got some cells with various string data. All of them contain-for sure- a sequence of characters like H500, H501, H600, H603 etc Is there any way to exctract only this sequence (H***) from each cell? Thank you in advance!

Dear friends, i have the following statement in a loop. For i = 1 To 20 If (InStr(1, Range("E" & i).Value, "Valid", vbTextCompare)) And (Range("D" & i).Value >= 10) Then ... End if Next My question is if there's a way to declare as following: Dim ValidVar as range Dim ValidVal as...

Dear friends, I have 2 workbooks. 1st contains the data and the 2nd contains specific cells from 1st workbook. Code is runing under a button in the 1st book. It's working for each raw manually, if i don't use the loop. Using the loop it doesn't copy anything. Any ideas? Sub...

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...

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...

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...

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)...

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

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...

Hello everybody! I need your valuable help once more! I've got a product database with a main product form and 10 sub-forms. Each sub-form loads in a new window, by pressing its button. Main ID is Record_ID and it's unique (no duplicates) for every product. Second ID is Product_ID which i...

Hello my friends! I need your valuable help once more! I'm trying to create a report which will contain only 2 fields: -ID (will be the same for all records) -Description (which will be different for each record). Maximum records will be 5. My question is, if there's a way to show in...

Hello everybody! Could you please help me with the following? I've got a subreport which contains 2 fields (ingredient and code). data example: Ingredient; Code --------------------- Ingredient 1; 1000 Ingredient 2; 1500 Ingredient 3; 1600 Ingredient 4; Not declared Ingredient 5; Not...

Hello everybody! I've got a form called ingredients (fields: name, code, date) In another form which contains a subform as a datasheet, i've got a combobox which source is the name field of ingredients. Is it possible, when the user selects an ingredient in the combo, when he adds a new...

Hello my friends, I've got a request for a database but i would like to lock the file so when the user will work he will not have access to tables/forms/code/design etc. An experienced user could use shift to unlock/unhide the tables/routines/forms etc. Do you suggest any way to totally...

Hello my friends! In my database (in a server with the appropriate user control, (single database file, not splitted), i got a sub which exports a report as a pdf and then creates an email with the report and another excel file (total 2 attachements). My problem is that in my computer (win 10...

Hello my friends! I've got a database which records incoming samples information. Fields: ID Sample description IncomeDate Customer Responsible. After inserting the information, a report is generating and a message is ready to be sent to the responsible. All the fields are included in the...

Dear friends, hello to everyone! I have a from and a report, which calculates the difference between 2 dates. The fields called [Accidentdate] (the day accident happened) and [Employ Date] (the employment date). On the same form/report, after i enter the accident date, then 3 different fields...