Search results

Thanks for your input, I have decided against checkboxes as the yes/no value tells me whether the record within my table should be still be displayed in the main form or not and the check box might be confusing for use. Also the fact that i can not adjust the checkbox's size helped in that...

Hi, I'm trying today to make a button on a bound form that would change a "no" value to "yes" within my table on the currently open record. I've tried this: Private Sub BtnFinalise_Click() DoCmd.RunSQL "UPDATE Tabule1 SET TabStatus = 'Yes' WHERE ID LIKE '" & Me!txtID.Value & "';" End Sub...

Hi, so i read the material from you guys, I thank you for it. However it still just baffles me, because I'm sure there is an answer to why this happens, out there somewhere. For now i'll just go with the conformist answer of: It happens because access is prepared to be recieving data inputs...

I apologize for now, going home now - i will get back to this tomorrow!

I'm learning access for a administrative job and i'm trying to learn as much as possible, trying to understand it's ins and outs because the company i work for (big truck repair shop chain in my country) is running mainly on access. So yes, just a purely academic question.

well yes, i know, but it just confuses me, because it makes no logical sense why it would behave like this. access is really something difficult to wrap your head around.

Now i tried clicking the entry button with 1s delay for several seconds, still resulting in gaps like 90,94,95,98 I don't understand.

Identical to yours, it only happens when i click really fast.

Just for clarification, the ID is a auto number column within my table and i have made a total of 19 entries with the last being labeled "39"

Hi, I have a form I'm testing out and i noticed that since i have null values enabled, i can just click the entry button and it creates a record with merely an ID and DateTime stamp, however upon spam clicking the entry button i started getting records with IDs that skipped several numbers, for...

Guys i just scrapped the idea of opening via date altogether as it was too complicated for no good reason. I have been trying now for well over an hour to make it open via the "ID" column and finally succeeded by going back to the original code i used to open links from listboxes and managed to...

to be honest I'm not sure i know how to answer this, but to my knowledge it wouldn't be a string as it's a "Now()" property in the column, so i guess it's just date/time type data, sorry, I'm quite new to access or vba in general.

althought i don't understand the slightest what diference you made, i suppose it's the dashes instead of the slashes, this doesn't result in an error, however, it only is able to select the first entry of the day, so i need the time value as well i think

I just realized that when going with these commands you guys provided me, i get the output of time in 13.13.13 format, though everywhere else the time is saved as 13:13:13, might be the problem?

yes it's true, this again results in a 3075: "DateValue(TabDate) = #04.28.2020." even if i swap dd for mm

Example of what gets stored "28.04.2020 13:13:13"

Format : General Date Default Value: Now() Date type: Date and Time (these are my guesses on the translation, my access client is in my native language)

This didn't work either, also error 3075 "TabDate =#04.28.2020." which is not my format anyway as I'm European, so i swapped it around to "dd/mm/yyyy" which results in the same error, i tried adding "dd/mm/yyyy hh/nn/ss" but it still results in the same error, only now it displays #full date...

This didn't work, it now thinks the date is on first row and outputs error 3075 "TabDate =#NameOfClient

Hi, I'm getting said error when trying to navigate to a record within a form based on matching dates, i don't understand why though, as I have the date format displaying the same way on both forms and same for the table where the records are saved. Any tips? Private Sub...