Search results for query: *

I'm trying to produce a query the will display a list of records of items that do not have a certain value in a connected table. The SQL Code should be something like: SELECT tblAssets.SerialNum, tblMeterReads.ReadPeriod FROM tblMeterReads INNER JOIN tblAssets ON tblMeterReads.SerialNumber =...

I can't figure out how to get the items in a drop-down both in alphbatical order. Does anyone now how to do that? Thanks.

Forgive me, because I know that this must be a pathetically easy question for may. For my website, I want to create an icon that when the user clicks on it, bookmarks the website. I want to make sure that, if possible, it works in all browsers. I would like to put in HTML code. Thanks!

I have a query that should idealy show all of the results from one table and whatever exist in the other. In other words, not every record in tblOne has a corresponding record in tblTwo. Yet, I need every field in tble need to be listed in the query results. I don't know if there is an answer...

I need to get the total number of days using a query. This would be something like; GetTimeFrame: [installDate] -#6/30/004# When I try the above, I just get a crazy date. If I try to change the properties of the output field to a number, it limits me to choosing a form of date. Please help!!!!

Greetings, I'm working on a report that needs to extend to its width length of 22". I'm trying to set up a report that is book style. I can't get the report to show more that 13" in print preview. Please help!

Greetings, I am trying to write VBA code that would save the record that is currently in another From. I tried this: Forms!frmMeterReads.DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Forms!frmMeterReads.DoCmd.GoToRecord , , acNewRec But I get an error when I execute...

Greetings, I am trying to write VBA code that would save the record that is currently in another From. I tried this: Forms!frmMeterReads.DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Forms!frmMeterReads.DoCmd.GoToRecord , , acNewRec But I get an error when I execute...

Does anyone know how to change the icons on the forms. I know how to set it for start-up, but that only show the icon at the top left and bottom and not on the forms themselves. Thanks, Noah

I have a Access app. that is almost finished. All of the forms and tables are in the same database. I am a little new to Access. The way that I understand it, if you have the forms in a seperate database than the tables, you can change the forms without having to worry about whats going on with...

Hello, I have a bottum that opens a continous form while applying a filter. What I need to do is apply two filters at the same time. I don't know if its possible. Here's the VBA code that work with just one filter item: Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I have a data entry from with a subform inside. If the primary key value in the main form is emptry, you can't enter the subform. Therefore, I created a button that assigns the primary key a value of zero in order to have something there in order to enter the subform. The problem that I have...

Hello, I'm trying asign a control on my form with a value from a query and I'm having a heck of a time trying to do so. I've been trying to put in VBA code in an event procedure. Any suggestions?

Greetings, I have a form that uses a query as the data source. When I have one table in the query, it opens normally. However, when I add a second joined table to the query, the form opens blank. Could someone PLEASE tell why soemthing like this would happen. Thanks

Greetings, Is it possible to hide a footer section if there is no data for that particular section (and show it where there is data). Thanks

Hello, I have a report that I need to export to excel. If I right click on the report and choose "Export" and select any kind of Excel file,it gets to proccessing up to page 4 (out of 37) and then just stops. It will export to word. HELP PLEASE!!

Does anyone know how to jump to the end of a report when it opens, either by a macro or VBA Code (or any other way that the user doing it) Thanks

I have a calculation that was really very complicated, so complicated that I could only get the calculation through running a certian report. I am using that much needed value in a secondary report. The problem that I have is that you have to manually go to the end of the first report before...

I'm trying to get the sum of a column which is the result of another query. I'm not sure how to get that value. Thanks in advance.

Hello, I need to multiply two fields from a query. I can add fields, no problem. Anything that I try doesn't work (I'm using the "*"). Also, I'm working in query design view. Any sugestions? -Thanks