Search results

Hi All, I'm making a program that displays database entries between 2 dates in a graph form. I want a new graph entry for every day even if there is no data on that day. for example, If a set the date range to: 08/01/17 to 12/01/17 and I have 2 records between those dates on the 8th and the...

Not familiar with log tables but just looked them up on google and if I've got the right idea it's something you call to make a log of the current date (which might be useful) but I only want to call it when I change the frontend. I should have mentioned that the frontend is stored on a server...

Hi All, I have a split database with a frontend that I semi-regularly update (when one of my users finds a bug I never would have thought for looking for). On my menu screen i have a text box that says: "Last Updated: ##/##/####". At the moment I manually update the date every time I update...

Thanks plog, you lead me down the right path. I'm posting the code i came up with here if anyone want it for future reference: maxdate = DMax("TestDate", "tblcal") lastcal = DLookup("CalPoint1", "tblCal", "testdate=#" & Format(maxdate, "mm/dd/yyyy") & "#") Me.LastCalText.SetFocus...

Hi All, I'm trying to make a form that shows what the last record was next to the empty space where you enter a new record. This is so the user knows that what they are entering is roughly in line with what has come before. So for example if I was recording temperature every May, I would like...

Hi All, I have 2 tables that have a one to many relationship between them. Table 1 is the details table (this information never needs to change) and Table 2 is the records table (a new record will be created every year). So for example: TABLE 1 ID ¦ Item ¦ Brand ¦ Units ¦ Model ¦ Serial 1...

Sorry I can't really post the database as it's a bit of a monster and this is only a small part of it. I've now created a botch cure to the problem by which I ask the user to manually save the form before I allow them to exit which stops the before update triggering the code. Couldn't find...

Hi All, I'm changing a record source on a form when the user clicks a "save" button. I'm doing this to store a value from the current form in a table that is not part of the default form query. This works fine. I have a separate button on my form called "Home", when the user clicks this...

Thanks Guys, pbaldy that's exactly what I needed. I tried everything but I would never have removed the "." from the "me." so would never have chanced upon that. Cheers

Hi All, This is simple task but I can't get my head round it. I'm incrementing a counter every time I click on a combobox by using the on click event and this code: POcount = POcount + 1 I have 5 fields on my form: GWS1, GWS2, GWS3, GWS4 and GWS5. I want to store the value of the combobox...

Well this is half in production. The Jobs table has been in use for about 2 years now and has 2000+ records but the purchase order table is new (at the moment we still do this by hand until I complete the mods to the database). So while I can re think some aspects I can't alter the structure of...

Hi All, This seems simple but I just can’t work it out. I have a form called “new jobs form” populated by a query called “New Jobs query” This saves data in a table called “jobs”. I have 5 fields in the “jobs” table called: “Purchase order number 1” “Purchase order...

Hi All, I have a form that is maximized to fill the screen which has a black background, This form contains a white square in the middle of the screen which contains all the controls. The last control I have at the very bottom of the white square is a combo box. When the combo box drops down...

I like the idea of a encrypted field as it simplifies everything, any idea how to go about implementing that?

Hi All, I'm trying to add hidden information to a record and need to know the best way to do it. I have a visible table that all users enter data into using a form. I also have a hidden table that contains 2 fields "linked Table ID" and "notes" I have a box at the top right of my form which...

Sorry CJ, I just edited my post to include information I missed out the first time I explained it. the datasheet view is locked for editing, I have a separate form in single form view for entering a new record. So really I'd need my data sheet view as a sub form within a single form and...

Hi All, I have a database with a large number of records: ~2000, so I use a form in datasheet view to filter and sort the records to find a particular one. This works fine for locating a certain record. Sometimes I then need to make a new record but I will be duplicating a few fields from the...

Sorry for the late reply, I've been working on this trying to get it working but I just can't do it. I've now got a query which contains fields from both tables. I've got a report which I've based on that query. I'm linking the on click event of the subform to some VBA that opens the report...

Sorry I wasn't clear, I would like to be able to press a button on the sub form so that a report is brought up using only the record selected on the sub form and its linked information on the main form.

Hi All, I have a form created from a table that contains item information. I have a sub form linked to a different table that contains records. Each item has multiple records associated with it, so for example 1 record on the main form could have 10 records displayed in the sub form...