Search results

I have written (what I think) is a great database, but when I came to install it I found out that the users I wrote it for did not even have MS access on their computers. Is there a way that I can save the FE in a different format, or is there a tool, that they can use the FE without having to...

I have a database that I have split into 2 parts: FE and BE database. For the front end I have switched on that it is compacted on exit. The backend however is not compacted this way. I did a manual compacting today and it went from 2MB to 200K !!! Does anybody know some code to also company...

Thank you for your quick reply. I in the menatime kept breaking my head over this email thing. I found two other examples from which I took some code and sort off got something working. The problem that I have in attached database that even though there are e-mailaddresses in the field on the...

I have a database from which users e-mail country specific reports to a group of receipients. I am currently using the following code: DoCmd.SendObject acReport, "Report UK", "SnapshotFormat (*.snp)", "rec1@company.co.uk;rec2@company.co.uk;rec3@company.co.uk", "", "", "Report UK", "See attached...

I know a lot has been written about above type of query but I think this problem has not been discussed before. I want to show per customer YTD and LYTD turnover and profit figures. I am now so far that via a crosstab query I am getting: customer Turnover 2004 Turnover...

A collegue of mine asked me to write some reports that compair sales figures between 2 date ranges. I have a table that stores invoice no, date, customer no and the date. I have created a form in which there entry fields for Date Range 1 (StartDate1, EndDate1) and Date Range 2 (StartDate2, End...

oops a problem when I try to enter this code in the query it says: "The expression you entered contains an invalid syntax"

great!! Thanks

Hi I am stuck in the following exercise: I have a table showing Order, DateShipped, PlannedDelivery, Late (Yes/No) and LateDate. From this table I would like to make a report that shows the delivery performance. I found a nice thread to show the working days, but when there is a late shipment...

forget this one..... problem solved duh :-)

In my database I have the option to sent a report via e-mail. The database is used by several people of which one of them has the problem that the sent e-mail does not appear in his sent items (outlook 2000). We confirmed with the recipient if he received the mail and they did. anyone seen this...

Thanks for your replies. I just read a thread about splitting the database. I did this and this did the trick. Table is now on the server (which get's backed up) and users have the frontend on their PCs

I have written database to be used by 2/3 persons. After finished the database on my PC I have hidden all database "stuff" (just the main form opens) and copied the file in a shared directory on my server. I have set under tools -> options -> advanced the default open mode to shared, but when...

I have written database to be used by 2/3 persons. After finished the database on my PC I have hidden all database "stuff" (just the main form opens) and copied the file in a shared directory on my server. I have set under tools -> options -> advanced the default open mode to shared, but when...

changed the form completely.... based on the query I have a continuous form that now shows me the readyshipments for the day. In the query I have set a criteria [please enter date] that pops up before opening the form - which shows the shipments. Still the question remains: can I not add a date...

I am finally able to e-mail a query to multiple recipients, but now I am getting an security warning from outlook. Is there a way I can add some code to below code to avoid this message? Private Sub Command32_Click() DoCmd.SendObject acQuery, "Sales Report", acFormatXLS, "joe@hotmail.com", ""...

Hya, Thanks for your quick response. I have now set the event in the afterupdate control, but the following error message "Microsoft Access can't find the macr Me." The date field has a default date: =date(). can I also have the event in onload or on open?

sorry for the late reply. when I open the form I set the focus on the field "CompanyName" This field has also tab 0

Hope I can make clear what I like to do: I have a company in Germany for which I have entered all e-mailaddresses in a table. Table consists of two fields: Name + e-mailaddresses In a form I have a button to send mail in which I used to have all the e-mailaddresses listed for the German...

I have now: Private Sub Command68_Click() On Error GoTo Err_Command68_Click Dim stDocName As String stDocName = "Label" DoCmd.PrintOut Copies:=Me.Colli Exit_Command68_Click: Exit Sub Err_Command68_Click: MsgBox Err.Description Resume Exit_Command68_Click End...