Search results

Ask the user how he wants to physically renumber the units if the 10th out of 30 is deleted. Who pulls the inventory from the warehouse and puts a replacement serial number label on each item. I am surprised that you are using an autonumber as the serial number. I would think that the serial...

Excuse me. I thought I would show a sample. Please forgive the intrusion.

@ClaraBarton Sorry for the delay. I don't check this forum for questions because people don't usually ask them here. If you ever need a reply from me specifically about one of my samples then @ me so I will know to come here. I suggest the same method if you need the attention of any other...

I've been creating applications with web connections for at least 15 years. Citrix and RDP both handle this task flawlessly and provide faster response time than even people using the app on the LAN get. For one of my apps, most of the users were in Connecticut at the head office and so used...

Thanks for confirming that because sometimes, it is actually necessary to code the sums on the Report rather than in the query. Understanding the problem will help others.

Thanks Pete

That sounds very strange. In this particular case though the Open event was doing TWO things. 1. setting the RecordSource 2. populating variables that are used to skip labels It seemed to have the correct values to skip the number of labels (unless she didn't bother to mention that error) but...

That is frequently the better way but my explanation is still important. Was that the problem the OP was having?

At least three different times, MS has tried to webify Access and failed miserably. Why? They were solving the wrong problem. What they needed to do was to rework ODBC to be less chatty so that Access could interface easily with remote databases. The current way ODBC works on a LAN is fine...

So, did you do what I suggested? Did you determine that the Open event is actually running? If you didn't stop the code there as I suggested and check the filter you are trying to use, you don't actually know what the problem was or that the variables are properly set in order to skip the...

That information is incorrect. Very much of the info regarding how Access works is simply made up based on the AI understanding of how other apps do the same thing. When the BE is Jet/ACE the autonumber PK is assigned immediately as soon as you dirty the record (type one single character in...

The AI knows very little about VBA and less about how Access works. All it can go on is what it finds on the web so it is learning from questions with more bad answers than good if you base that assessment on the number of posts in any given thread. In the past few years there have been...

Yes. They think they are protecting their product which is much more important than the lowly "Access".

Your question is a bit snarky but it's actually from personal exchanges with the SQL Server regional manager and other reps at different client installations. They are all convinced that "Access" is only an inferior database engine. They KNOW this because they were responsible for Jet and that...

Put a stop in the code in the Open event so we can be sure the event is not triggered. And also check the value of the filter if the code is triggered.

Have you compiled the database? Are there errors? You cannot convert it until these are fixed. When did the code stop working? Did a MS update happen just before the code broke? Code that has been working doesn't simply break. When that happens it is generally one of two things. 1. The...

This breaks my heart. But it tells me that the Access team has no juice or fails to use what they have to get a mention. Also, and most importantly, the SQL Server team thinks of Access as a competitor because they don't even know what Access is and they think of it only in terms of Jet/ACE...

You haven't given us enough to work with but my first guess is that you are referencing control names to create your total but you need to actually recreate the calculation: =SUM([OTCASH]) + SUM([OTCOMP]) + SUM([LEAVE]) +AVG([Hourly])) rather than =Sum(CashSum + CompSum + LeaveSum + HoulySum)

Welcome to AWF. You might want to spend some time actually trying to understand how Access works. Access is a RAD tool. It is supposed to do things for you. That is the point. It also looks like your tables are not designed properly. That is a common problem when people who are accustomed...

Use the MSysQueries table. Search the Expression column for "Form" Then use the ObjectID to find the name in MSysObjects - OR create a query that joins queries to objects and search the query.