Search results

Quick quesrrion regarding date validation. i looked for an answer but found zilch. User enters a date and in the Before Update process in the form, I check to see if the specified date is greater than the current date or more than a year in the past. Also want to store the results from the...

For Plog, I did revery to massaging the data in excel for most of the data. However, there were a few tables that needed programming decisions.

You guys are great. Thanks

Well duh! my problem was that I needed to put the date in quotes.

Thank you. The last one should work. my Latest problem is that I have a number such as 1.5 in excel, and when loaded into access, it turns it into 1.499999999 my data contains many 1 and 2 decimal place number that are getting screwed up. I am tempted tto multiply the source by 100, transfer...

Also, what do you do when a field data is null when it goes in the SQL statement. The SQL statement just shows “…, ,…”

I am converting data from an Excel table into access, and then going through the non normalized data and inserting data into proper tables. My problem is that a date is not converting properly. The date is stored in the conversion table as a date - 05-15-21. i include as a record set field...

Gadzooks. Never heard of that. Hit the Insert key and it now works properly.

When I put the cursor in a field, the app blacks the closest character rather than putting the cursor between the characters. What do I need to change to stop this? Thanks

This is a one person operation, and he keeps all his records manually and uses the automated tools for reminders and for student records. I believe that the table following table list should be sufficient to purpose: 1) a basic code table to define the inspection/maintenance criteria names 2)...

I am sure that this has been answered before. However, I did not see it in recent threads. I have two instances where a user need to see the latest information on multiple criteria or records associated with a single event that evolves over time. For example, - an aircraft has several...

in understanding a business, I focus on a data model first. Reading through a business mission statement or any business overviews gives you the types of data subjects you will be dealing with; e.g., in a court system, you would have judges, courtrooms, documents, schedules, defendants, police...

Take a look at the latest video from YouTube channel 599cd.com. He has a lot of Access instructional videos.

Um, it removed the site address when posting

good day, eh! Has anyone checked out this Access add-in that allows Acces to execute on other devices such as a Mac or an iPad? Not shilling for the guy or anything, but I thought it would be great to run my Access app on my iPad? https://599cd.com/blog/display-article.asp?ID=2229 curious...

Yes, changing to overlapping forms did the trick. Now I can fix the size of the opened form window to my requirements. And after saving the form, the dimensions and placement remained the same. For the invoked/opened forms from the main menu, I adjust the placement before display using vba...

I am working through the forms in 2019 Access as i migrate from 2003. in 2003, I would simply adjust the size of the design window to reflect the actual size of the display window when the Form is opened. The form design window and the properties sheet were detached from each other and the...

Thanks again

Introduction try 2 - no questions this time I was an IT architect and consultant for about 35 years. Now retired. Born and worked most of my life in Canada, from cities in the east coast to west coast. Met a wonderful lady online playing war games ten years ago. She lived in South Carolina...

flying instructor. 😊