Search results

You can always delete all textboxes and re-add them to make SURE you don't have a typo.

Step 1 would be to set up a query on your table. Query would be on Person ID, your primary key, and [Event Start Date]. Step 2 is to call this query with a where clause based on your current record's [Event Start Date] that returns all entries within 4 days of your current [Event Start Date]...

So in the form you are entering request events, look to see if there is a previous event (within 4 days) and update that instead? Or are you looking for something different? The issue with your post is I don't know if you want to combined existing data or future data. For existing data, how do...

Would need a LOT more information on the business application for "Cluster together". Please list the exact business rule(s) you are trying to enforce.

Can you walk through what you expect your USER to do and at what point in the USER experience the email needs to be sent? I am guessing "User goes in to parent form and creates/updates/selects parent record. User then goes in to subform and creates one or more child records. User then needs to...

From your data, it looks like you have 6 columns per record that cover "Semester". It looks like you can keep the enrolled term and delete the rest. Before doing this, make a list of the "Enrolled term" codes and have a separate list that tells you what each means. Cutting down the redundant...

From your description, you should have been able to remove about 60 columns from your excel spreadsheet BEFORE you tried to import it.

I would suggest re-reading MajP's post #5. Using bound forms and a normal form-subform structure would have accomplished this in an hour, at most. If you have invested more than an hour in "solving" this, you will want to learn how Access is designed to work. It will save you an immense amount...

What does your scanner output?

Please note, you may hit a similar issue in the future. Access does not always like non-PNG files. Database I'm currently keeping up only has about 500ish images that it displays. Found out early that if they were not PNGs, some would not show on reports.

Last "WIDE" report I had to do was for manpower management. For a joint task force I had to show each position in the task force, who was in it (horizontal bar, vertical lines for end of week) and when they were arriving / departing. Needed to show overlap for handover and the nice gaps for when...

Where does each client save their copy of their FE? Just making sure they are not all trying to use the same copy of the FE stored on the server.

You are asking on an 8 year old thread. The poster has not posted in 4 years. I am hoping someone can help, but I wouldn't expect MBMSOFT to respond.

I'd ask Google to check Microsoft's documentation; https://learn.microsoft.com/en-us/office/vba/api/access.docmd.transferdatabase DatabaseType is the 2nd parameter. They don't list Microsoft word in there.

I've had my toes in Kuwait bay, but that experience did not give me a desire to head back. Much preferred the waters in the Caribbean.

From the look of the files, this is a flat file broken out into multiple tables? What is your end goal? If this is imported and you are trying to only bring in what you need, I would suggest going about this is a different way. If this is something else, please share what you are trying to...

For updates on the fires, check out https://www.fire.ca.gov/

Did you at least make sure you were wearing your PROPER running with scissors gear?

For "Northern California", I'd be looking north of the central valley unless you have no allergy issues. Anything in the valley is surrounded by agriculture. I'd suggest going someplace like Redding to see if you like the area. Talk to the locals about the good AND bad. Biggest issues is wildfires.

Deke Hikari, you are not looking for an inventory management system, you are looking for scheduled rentals. BIGGEST difference if your "inventory" does not follow the normal rules for inventory tracking. Rather you are scheduling resource usage. This means that, rather than checking how many of...