Search results

Hi all, As per the title, is there a function that will let me check if a value that was input is divisible by 6?

Hi all, I am required to write a code that will allow me to generate a table at the click of a button. Is there such a thing? The table name should be Table1, and it contains 7 columns. First column: Auto number (PK) Field1: Memo Field2: Memo Field3: Memo Field4: Memo Field5: Memo Field6: Memo

Hi all, I have a table that contains many records of events. I've already created a multiple item form based on the table. My form contains 2 textboxes for input of a date range and a dropdown box to select "yes or no". What I am having difficulty with is the query that will count the records...

Hi all, I am trying to create a form that will select records by date range. The form contains 2 textboxes, with pop-up calendars to select dates. I managed to come up with this code, however, it's not working. Whenever I run the code, my database just goes blank, as though it's selecting...

Hi all, I have 2 tables. Table 1 contains 2 columns: Details and event type. Table 2 contains 2 columns: Lookup and event type. I am required to write a code that will allow me to read the string of each record in the details column, and if the string contains a certain text, it will input...

Hi all, I have managed to sort out the data to be used in the final table. However, I am having trouble transferring the data from each of their own tables into the final table. Each time I run my code I receive "run-time error 3021: No current record." It seems that only my timestamp is...

Hi all, I have an imported table and within this table contains a column that needs to be further delimited. I've read that it is possible to delimit columns using the left, right and mid functions, however, I need to delimit it to more than 3 columns. Maybe an estimated 6. Examples of the...

Hi all, I am required to write a code to check the positioning of a text in a string. E.g. "~[Admin]~xxxxxxxxx~ACK~" = Acknowledged "~xxxxxxxxx~[Admin]~ACK~" = Not Acknowledged "~xxxxxxxxx~ACK~[Admin]~" = Not Acknowledged As you can see, as long as the string starts with "~[Admin]~", it is...

Hi all, I have a column containing records of the timestamp of an event. I need to extract the date out of each of these records and put them in a separate table. The date and time of each record is contained within a bracket. E.g. ES~1~1412179200(Oct 02 00:00:00 2014)~1~ITM_W64MQMONITORLOG00~...

Hi guys, I am having a little difficulty with my importing in Access. Every time I import my text file, the lines will be jumbled. I have been reading up and I found this recordset code that seems to be what I need: Dim strLine As String Dim intLineNum As Integer Dim MyDB As DAO.Database Dim...