Search results

You're Welcome. Glad we can assist. If a REPAIR is required, then it is important to first make a good backup. Depending on what caused the corruption, doing a repair can fail and destroy the database beyond any ability to retrieve anything. I have tried to help people recover a database after...

Under normal usage, you do NOT want any user to hold down the shift key to open a front end in production. When I deploy my front end, I disable the bypass key so holding down the shift key will not work The shift key used when opening a database is called the bypass key. This will "bypass"...

I do something very similar using two tables. . Main Table: Messages: Child table: Messages Views The Message Views table is a log of when each user views, in your case trashes, a message with a date/time stamp and the Computer name. The Message View table looks something like this...

First, in the WHERE clause of the SQL statement, is [LeaderID] a numeric field data type? If a text data type then you must use the string delimiter like this: ... Where [LeaderID]=" & Chr(34) & Me.cboLeader & CHR(34) Second, in SELECT part of the SQL statement, are you entering the fields...

I assume that you are not using the Before Update event of controls or the form to do any validation. I use the Beoifer Update event besue I can provide a better user experience with my own messages and other UI features. I use the database engine rules as a safeguard. That indicates that you...

Maybe I am missing something here... If you have a website that uses MYSQL on the back end, why are you not simply exporting the data from Access to a CVS and importing it into the MYSQL database? Or even better, in Access use linked tables to the MYSQL database and "push" the data in the...

Something like: Private Sub Combo1_AfterUpdate() Me.Combo2.RowSource = "Select ... Where [FieldName] = " & Me.Combo1 Me.Combo2..Requery End Sub

I agree it would be an interesting discussion. I think part of the confusion is the forum used. If this were posted in the forum Theory and practice of database design and you stated clearly on the first line that you were opening discussions about ideas for what other people used then you...

Why do yoy need a UNION query when a totaling query with calcuated field can do it?

When dealing with programmers/coders it is always best to be as specific as possible or you will probably not get the answer you are looking for. When you a programmer/coder an open or ambiguous questions Here is what they hear: Like in the movie Phenomenon, where is what it is like to ask...

I agree with theDBguy. When it is critical for a field to contain data, then I set it as required at the table’s field level. If you set the field as required at the table level, there is no way to avoid entering the data. Even if someone were to manually enter data directly into the...

I find it best to use VBA code in the after update event of the Primary combo box to set the row source for the dependent (cascading) combo box control to avoid any issues with form references.

I agree. I t can easily be done with a single select query using calculated fields. that are summed up. No needs to create multiple queries the overhead of the additional UNION query. I do it all the time in account systems to get aged receivables and payables reports that are broken down in...

How I handle this Developers and deployment tools are not the same as admin tools. Admin tools are deployed while the developer's tools are not. I have tried both ways, but found Admin tools are best in a separate front end. (items 1 and 2) I deploy all Front Ends as compile databases...

Have you try simply adding a WHERE clause to the SQL to filter out blank rows. WHERE WorkItemstemp.IDcardNo Is Not Null Like this in Command18_Click() StrSQL = "INSERT INTO WorkItems ( IDcardNo, Roster, meta )" _ & "SELECT WorkItemstemp.IDcardNo, WorkItemstemp.Roster, WorkItemstemp.meta " _ &...

Just because a computer will respond to a ping. does not mean the shared resource is available. What I do is open a text file in the folder with the back end. If it is successful, then the back end should be available. This could be a dummy file with any extension, an INI file, etc. I...

I see this happen when the Excel file is not properly cleared. I would first try adding a WHERE clause to the SQL to filter out blank rows.

From what you just described, it is definitely possible to use a single report (you are now when you copy a template) and never need to go into design mode at runtime. I know it is possible since I have users that run reports daily doing what you need with a compile front end ACCDE with an...

Have you tried using a Crosstab query? I have posted this example of how I use a Dynamic Report based on a Crosstab query in some of my Access applications. If this were my project, I would use the Schedule Grid - DesGrid to display the data on the screen. It will teach you a lot about...

What is the data type for the field Appointment?