Search results for query: *

I have a filters private function on a form, to dynamically generate the SQL for the record source on a subform, for searching records. I run this onload of the main form, and afterupdate of a series of text box (dates), comobo box, and check box controls. Below is the Filters code. When the...

I have 3 combos. The first one is to pick the type of voting panel. Some of the options are a panel type (column(2) - hidden) of a person, the others are a group. If the type of voting panel chosen is a type of person, a person combo is shown. If the type of voting panel chosen is a group, a...

I typically make a Visio database model diagram, doing a reverse engineer feature. My issue now is that I have Visio 2010, but I need a model for a database on a 2014 server. It seems the Visio driver in 2010 is not compatible for SQL Server 2014 database connections. I tried the generic ODBC...

I have a subform with a datetime field (linked from SQL). It shows a calendar picker, but doesn't show the time. I switched the format to long date, and that didn't work. Anyone know what I'm missing? Users need to be able to pick or enter date AND time into the field. I've been...

I'm looking for a tool (preferably free or free trial) so I can document all objects and such in an Access database. I am looking at replacing a linked SQL view, and will need to know everywhere I use it. Whether it's a record source for a form, row source for a combo or listbox, or if it's in...

I have some functions, on certain forms in an application, which take a while to run. I want to set up some simple debug.print messages to capture the time I start the function, and the time I start and finish each step of the function. This way, I can isolate which step is taking the longest...

I'm following through this thread: http://www.tek-tips.com/faqs.cfm?fid=6295 and I'm confused. It says the combo should have 3 columns, but only explains what 2 of them are. Anyone able to determine what I'm missing? This is the section of the code, about that part: ' Column Count 3 ' Keyed...

I know this is a pretty general topic, but I hope no one will get mad at me for asking this question here. I have an application and because of how it will be used, I want to make sure it is set up in a way that has tight control over what records people can delete, and which combo values can be...

I have the following structure: Contact (ID, txtContact, txtNotes) Match (ID, FKContact, txtMatch, txtNotes) Contact Match Record (ID, FKMatch, txtsomestuff, txtNotes) I user starts a new record by assigning it to a contact and a match. Now we have had to add 2 extra tables to the structure...

I have been searching for a way to limit the values in a combo box, so that records already added in a continuous subform can't be chosen again. Weird thing is, I'm not seeing this as a common thing to do. I have a subform with "requirements". The sub form has a combo with requirement types...

so this is odd. I have ensured the recordsource is updateable. This was working prior, but who knows what of the 89097987 attempts I've made at getting this all to work, that was. I have a form for records. The detail is visible = false on load. The header shows with buttons to look up a...

I have a form that has the detail visible = false, until a user clicks 1 of 2 buttons 1) Look up Record (filter combos to view existing records in listbox - choose one, go to record) 2) Add New Record For #2, a form pops-up, and I make the main record form visible = false. The user has to...

I have a database with a SQL back end. This is the process I am currently debugging: 1) Open application to Main menu 2) Click button on main menu to go to the "Main Record Form" 3) Main record form has detail hidden until an existing record is found or a new record is...

I have data like this: actdate time1 time2 1/1/01 12:05 PM 2:10 PM I do a datediff formula in a query, as follows: DateDiff("n",[TimeTable]![time1],[TimeTable]![time2])/60 problem is that I get a result in the query like 2.08111111111 I want to round to the nearest minute/ 100th decimal...

I have data that I received which is not normalized, and I need parse it out, so I can import it to a normalized structure. I have found cte's and split functions, but only for 1 multi-value column. Nothing for 2 or more. The data looks like this: ID fname lname projects projdates 1...

I'm trying to just make a simple connection, so I can learn how to query info from sql server on a php page. So far, none of my attempts are working at all. I get no errors, no results, nada. Below is my code, if anyone can help me figure this out. Thanks! <?php echo "<h2>Project Group...

I get this error in my form command button control, in the on-click event: Run-time error '3075': |1 in query expression '|2'. -------------------------- This is the code in that event: Private Sub cmdExDetRptSel_Click() Dim strDocName As String Dim strcriteria As String Dim strOpenArgs As...

I have a report that has 2 groupings and 2 sortings. I want to use a form to dictate whether the top grouping (GroupHeader(0)) is on or not. I have it partially working, where it doesn't show the group or it's 1 textbox control. But the 2nd grouping still seems to group it's data by the first...

I have a listbox, which I set the row source on click of a filter type button on a form. The row source I set is a public function, which takes 2 parameters. Originally I tried a stored procedure, but found that you cannot set the row source for a listbox to a stored proc. I converted this to...

I have an application with projects. In each project, there can be multiple pieces of media. We upload 2 inventories of that media. One is at a folder level and one at a file level. One piece of media could be a TB HDD. A subset of the media is what sources are on it. I have the front end...