Search results

Hi, I want to create an Access database that sources data from a SQL Server database and then use the Access database independently for different purposes. I would like to be linked live to the SQL Server, via ODBC, so that info is always current but don’t want any risk that the data in the...

Hi, I have a report that has the page number displayed in the footer. This was set up using the Page Number icon under Design, Header/Footer. Everytime I open the database and run the report the page number appears as #Name? If I use the Page Numbers icon to set it up again it works. It...

Thanks, I did find this out by playing around with it after I sent the last reply. But thanks for your help. Dave

I looked at DLookup but couldn't figure it out. Very confusing. What would the Criteria be? Thanks

Hi, I have a report and want to set the value of a text box to a value from a query (Field "Week1Start" from Query "qryWeekDates") that is not part of the record source of the Report. I have tried setting a On Load event: Private Sub Report_Load() [Text70].Value = qryWeekDates!Week1Start...

Tried DLookup. It is way too complicated and very unclear as to what it expects to see in the Criteria...

Hi Forum, I have a table that has a column of Equipment Numbers (e.g. CN330) and another column with corresponding costs. The Equipment Numbers are not unique. A number may appear many times in the column and the cost may be different each time. (The source data for this is an Excel...

Thanks, GHB, thats all way over my head. I don't know what a record set is. but thanks ArnelGP, this is a bit over my head too but I will have a look at DLookup Thanks

Hi Forum, I have a report based on a query. I want to populate 6 Text Boxes with Dates from fields in another query. The date fields I want to add will be headings for columns that represent weeks (they change all the time so can’t be hard figures). The two queries are not really related by...

Thanks guys. Plog: If I had the slightest idea how to create a custom function I would do so. Thanks for taking the time to reply. James: Thanks, I'll try Null Dave

Hi, I have an IIf statement in a calculated field in a query and it looks for 4 conditions. It works fine when any of the 4 conditions are met but in cases where none are met, and I want it to return nothing, (" "), it returns #Error. What is wrong with the formula? 10Jul15...

Thanks, I don't really understand any of that. But thanks anyway. Dave

Hi Forum, I have a query with a Date field for EndDate (the dates for end-of-week, Fridays in our case) and another field for Sales (number of sales, not dollars). I want to add 4 calculated fields that represent weeks and have the Sales appear in the correct column (field) for that date. So I...

Hi, If I have four date Fields in a query, Astart, Bstart, Cstart, and Dstart and want to have a calculated field to find the latest date for each record how would I do that? I have tried things like: LatestDate: MAX(Astart, Bstart, Cstart, Dstart) Thank you very much Dave

Hi, I have three reports that I have used as the subreports for one master report. The master report shows the three subreports on a page. When one or more of the subreports contains no data the master report still shows the empty subreport. I would like subreports with no data to be left off...

Thanks very much, CL_London

Hi, I want to have a Combo Box on a form, that derives its values from a Table, but does not send selected values to another table. I want to use the value selected in the combo box in VBA code. I have set up a combo box, without a control source, and it shows the values in the drop down list...

That works, and is a lot easier to look at. Thanks very much

Hi, I have this segment of code that adds data to fields FName and FPath in the table “Files”. It works fine but the syntax is a nightmare with all the double quotes and “and” symbols. I don’t really understand it. strSQL = "INSERT INTO Files " _ & " (FName, FPath) " _ & "...

Hi, The code below opens a PDF selected from a form. Whatever document number appears in the textbox (FICNo) on the form is the document that is opened when the command button is clicked. It works but I would like to add a message box to say “File not found” if the document number in the...