Search results

Add a field to the query of your report. Groupdate: iif([true/falsefield] = true, " ",[datefield]) Then use that field for your grouping.

I am trying to Create a Menu Bar that Is identical to the Access Built in Menu bar with one exception. I do not want the Unhide command on the Window Dropdown. I cannot edit the built in toolbars because other access files run from the same machine may need the unhide button, and I need the...

Are the coordinates stored in seperate fields, and are they numeric? If so, SELECT * FROM Tablename WHERE ((tablename.Xcoord > ([Starting X Coordinate]-[X Coordinate Difference]) AND (tablename.Xcoord < ([Starting X Coordinate]-[X Coordinate Difference])) AND (tablename.Ycoord > ([Starting...

Assuming there is no data in the table. Compact the database. If there are records in the table, this will cause it to start incrementing off of the highest value.

The control source should be the field that you are storing the ID in your subtable. Set the default value of the textbox of your popup form to be =[Forms]![PatientForm]![ID] Depending on how you want the popup form to act, you may also need to set the filter of your popup form to only show...

Can you post the the SQL statement of your query? I think dcx has the right solution, but that you are misunderstanding where he wants you to put it.

I dont know if this will help or not, but about 4 years ago, the database that I built for our company was having the exact same problem. It was compounded by the fact that it was replicated, and so if we repaired it, it lost its replication. (Jetcomp finally fixed that problem) We had...

Its been a long time since I have dealt with it, but as I recall, with Acc 97, you can rename the system.mdw file so access wont find it, and then open access. As I recall, it will not ask you for a password, and will give you full rights to it. Your application likely will not run properly...

It looks to me at a glance that your DO LOOP's should not be nested. Try moving the : Do While Not EOF(1) to just below the first Loop Right now the code is cycling. Finding the heading row, inserting the heading row, then inserting the first record. It then loops back and starts...

Would adding check box to the table and marking the 200 records with true be an option? Then any user could query for the records that are true and get the same result set.

I'm not sure I understand where your suggesting or exactly what your suggesting I try. I was under the impression that IDENTITY_INSERT was at the table level, not the database level. I'm willing to try anything, but not having luck with any form of syntax to what you are describing. Here is...

Hello, I have run into a minor annoying problem. First a little background. I am currently redesigning my companies database application. The original application was done entirely in Access 97 and replicated across multiple sites. It is also used seperately by different divisions of the...