Search results

Why would you want to store the email(s) in "t_dci" when it is already in "resp_acc"? In general you better not use multi value lists.

I think an Else is missing. If the length of srvCBO not 0 you fill email and make it empty right away. Put an Else between those two lines. I don not understand the sense of adding "" to srvCBO.

Then only one record will be shown. The wish was "only last record by date". So 1 record. Edit: If the time parts of a same date differ, your query will also select 1 record.

Can be done 1 query. SELECT TOP 1 * FROM YourTable ORDER BY DATE_ DESC Even arnelgp's solution can be done In one query using a sub-query.

That is the right approach!

I agree with plog that having so many forms looks like a design problem. What table do you have? An other problem with your code might be the event that triggers it. I think the trigger should be the after update event, not the on click.

Is it perhaps an option not to upload and download directly from the application via ftp? Export and import the files to and from hard drive. Sending and receiving via ftp also runs via HD. The application will then not be bothered by the slow ftp.

Try Private Sub datebox_Click() Me.datebox = Now() End Sub

Create a separate update and append query. It is important that you always perform them one after the other in the correct order. I assume that table1 can and should be emptied afterwards. You should therefore execute the following queries in one and the same procedure. UPDATE Table1 INNER JOIN...

Try something like this: SELECT qryVacationProgressList.EmployeeID, qryVacationProgressList.EmployeeName, qryVacationProgressList.CompanyName, qryVacationProgressList.MaxOfLeaveDate, qryVacationProgressList.BranchEn, qryVacationProgressList.Status, "Progress - Vacation" as Type FROM...

A function returns a value. This one should return True or False. You have to assing the returned value to a variable. Something like YourVariable = SendstrTo("192.666.1.501:8888",strData, 10)

I see two potentiaal solutions. First (and best) is not to use a query for each type of application. Use the main query in your report and use the grouping options in report design to seperate the types of applications. In that way you also do not need to change anything when a new type of...

In addition to the correct solution of CJ_London: if you want to round the results to 4 decimal places, you can use the following functions. Format(Avg(Pressure),".0000") AS AvgPressure, Format(Avg(Temp),".0000") AS AvgTemp

I admire your courage to jump in at the deep end with Access. Your data model looks absolutely fine for a beginner. Of course I do have a few questions and comments. In many relationships, the property to enforce referential integrity is disabled. Normally you only turn it off in very...

As mentioned in a previous response, you will first have to get the structure of the database in order. Based on the structure of the csv file, I arrive at the following database structure.

Hello all, I am Peter from the Netherlands. I have many years of experience with Access. The first version I worked with was the one under Windows 97. I joined this forum to help people whenever possible. My experience is that thanks to the questions and answers on these kinds of forums I always...