Search results

but i want the user to be able to insert a new record if he can't find it on the list.

Hello, I have a combobox that is bound to field CustomerName. The combobox has 8columns and each one is being assigned to a field in the form after the combobox is updated. If i write a CustomerName that is not on the list ( i set the Limit Property=No) after updating the record i get #deleted#...

That's a temporary table i use for a report. The report format must be like this: One column for the company name and one column for each F field. If one company owns one or more products with code=101 for example then the F101 must be checked on the report.

This is how it goes... Table tblCompany (Fields: CompanyID,....etc) keeps info about different companies and has 1-to-many releationship with table tblProducts (Fields: ProductID,CompanyID,ProductCode,....etc). Table tblCompany also has 1-1 releationship with tempRegistry table (Fields...

Hello all, I have a temporary table with Yes/No fields (F101,F102,F103,....etc). In another table i have a field called ProductCode with values (101,102,103,....etc) Is it possible to append(or update) the records of the temp table with criteria on "F" &ProductCode field? (For example if...

Thank you for the help:)

ok i will thanks!:)

Can you give me the links of those similar threads? I have already search the forum and i couldn't find anything, maybe i'm using the wrong keywords. Thank you for your answer.

Hello, I have a subform with a combobox (combo1) that is bounded to another combobox (combo2) of the same subform. At row source of the combo1 i use the criteria [forms]![subfrm1]![combo2]. When i open the parent form i get an input box for entering [forms]![subfrm1]![combo2]. How can i call...

Hello all, I tried to send emails using CDO through SMTP Server and works fine when i use a POP3 account for receiving the emails. If i use Exchange Server for receiving the emails i can't receive any of the emails CDO sends. Is it possible to send/receive emails through Exchange Server...

Thank you for your answer :) This setting will act for all applications or just the particular? Because i don't think is a good idea to set low security for all applications. I also tried not to use outlook and send emails through CDO object. Is it possible to send emails to exchange server...

I have the following function that runs through a macro: Public Function sendEmailF1() Dim strSQL As String Dim rs As DAO.Recordset strSQL = "SELECT * FROM tblContactClients " Set rs = CurrentDb.OpenRecordset(strSQL) While Not rs.EOF If (DateAdd("d", 2, rs.Fields("InsDate")) = Date) Then...

I'm sorry for the latish answer but i had a problem with my pc. Dennisk i tried your solution and it seems to works! Thanks again for everything :)

I'm doing this because I notice that if I don't use the requery function and user change the value of combo1, when i click on combo2 I get the choices that I was getting before I change the combo1. I'm sorry I didn't understand what exactly i must do... can you explain to me how to do that...

The recordsets are not large at all (5-6 choices each one). I think the problem is because i run requery function for all remaining comboboxes after update event on each combobox.

You can create and save the query, and then use it as recordsource of your form (instead of using a table as record source). The problem is that you can't change the data of a record source based on a query.

Hello, I have a form with 5 comboboxes each one combines to the previous combobox. After I update combo1 i use requery function for combo2,combo3,combo4,combo5. After I update combo2 i use requery function for combo3,combo4,combo5 and so on. The problem is that the form is getting really slow...

Thanks RoyVidar for all! :) and the links are pretty useful!

You have right for the WHERE clause, i didn't think about it (i just sorted the CounterTable based on MonthNo that might causes wrong results) thanks :) For next year i thought of building a function (autoexecute it as macro) that checks if Year(Date()) > [CounterTable].[Year]. If true then...

I found the solution in case someone else is interesting:) i added the following in the code and works If Month(Me.SampleDate) <> 1 Then MsgBox (Month(Me.SampleDate)) rs.Move (Month(Me.SampleDate) - 1) End If NextCounter = rs!NextAvailableCounter ..... where SampleDate is the date i'm...