Search results

Hey guys. I wrote a massive email with lots of details etc. about my issue just, but I was logged out before it posted and I have lost it all. I'll try to be more concise this time. I've been left with a database someone else built over two years ago and an issue has recently cropped up. Part...

Hi. I am having some trouble with formatting dates in my database. Ideally, I want every date to be in the format of dd/mm/yyyy but there is one point in my database that it keeps flipping to mm/dd/yyyy and I can't figure out why. I've tried many variations of Format(date,"dd/mm/yyy") etc. so I...

Hey. Basically, my question is as the title suggests. I have a table which is populated via an INSERT SQL using VBA to adapt to the information that I want to store in the table. If the SQL adds a new entry but the field isn't specified in the SQL, it sets 0 as a value. On my form I have a...

Hey I have a query which I have built up in VBA to allow a quick and easy way for the user to edit a record (without having to delve into the tables etc.). Fundamentally, the data from that record is retrieved to a bunch of textboxes on a form, with a button to "save" the changes. The user...

Hey. I have a form which contains 5 textboxes which are pre-populated with some information from a table. Fundamentally, I want the user to be able to make some changes and save it to the table (without being bound in case they change there mind etc.). I have some VBA script which runs when...

Hi people. I'm new to this forum, but not truly new to Access. I currently have a system whereas I have a single table containing some information regarding on-site radioactivity. On a form, I have a listbox displaying some information from that table or, if the user checks an appropriate...