Search results

Nice work :D

I don't know much about your field or project. But from what I've taken this far. The following db design should work and provide the possibility for an easy to use form design: [CODE] TABLE FIELDS ------------- -------------------------------------

How does this look? *NOTICE* ERR in table for question five is due to a duplicate answer letter. *NOTICE* 5. A query can do which of the following: a. display less fields than the underlying table b. make a table c. update a table *a. all of the above *NOTICE* Generated by this code...

I've got it done, just have to handle a random byte character that show up here and there.

Wow is this all of the variations or is there bound to be more?

I'll be back tomorrow to check and see how you're making out. I'm too tired out to even think of a db design and front end solution to this right now. Time to go home in 10 minutes! :D

With my getfilelines function you could do something far more simple: Public Sub ImportData(file) Dim str_line As Variant Dim var_split() As String Dim rs As Recordset: Set rs = CurrentDb.OpenRecordset("table_name") For Each str_line In GetFileLines(file, True, True...

Replace Chr(10) and Chr(13) with vbNullString? You may have to do this from a byte array, you may just be able to use the actual Replace function.

Is this a database design question or a form design. I'm thinking both.

Oh by God you're right haha. I started with a singular database for development and in the process of splitting it up between front end and back end I linked the tables to the main database, before switching them over to the backend one. Derp. Thanks dude :)

Anyone have any idea as to why this wont work. I wasn't able to find any information online. I'm sure there is some but I'm a bit groggy today... The image below describes the scope of the issue. The function is called upon in the onLoad event of frmMain. Thanks! Blue

You may have to call a set focus in the onCurrent before you set its .SelStart to the length of its value.

If A right off the bat says that they know that B doesn't know at first glance. A must have seen the distinct days within the two months, knowing that they would be the only way B would instantly know the birth date. The only way he would know that they weren't is if the month he had was not one...

Just sticking with the initial request. I also enjoy creating such dynamic functions that display themselves visually to the user. Complicated for the developer, quick, less irritating than a dialog box and nice on the eyes for the user. :P

I agree with August 17th actually :P

This is something I quickly whipped up for you to start with. I'm very sure that it will need more testing and some proper validation parsing, but it is a start. Place this in a new module named _Util or something. Public Sub ValidateControl(ByRef ctrl As Control, ByVal data_type As...

Sure it is but you're going to have to plan out points of validation parsing and also what your valid values are.

I'm thinking June 18

You gotta replace the names in the code to match your form controls lol

the form resize event