Recent content by Demona

Quick question ... I have a bunch on checkboxes on multiple tabs on a form. I just wanted t know if it was possible to keep the same format for all tabs as I want them to look fairly similar. Can the format be copied from one tab to another? It would be a real pleasure to build the rest of...

Hi Guys, I was wondering if there is a particular way to keep the formatting straight in SQL code. I got lost with all the () and & and ; and [] ... any suggestion would be appreciated, then I wouldn't have to guess where brackets etc are supposed to be. Thanks Love and Kisses Demona

Hi Guys, Just a thiught on reading a port on rotating logos ... can a JAVA Applet be used in a Access DataBase for effects? :cool:

Oops I guess you need more code to really make an educated guess. Sorry guys.

This is the query that is being built for me by the code Set MyQueryDef = MyDatabase.CreateQueryDef("qryDynamic_QBF", "Select * from [Data Output]" & ("where (" & Mid(Shift, 4) & "" & Mid(SubAreas, 4) & "" & Mid(EMO, 4) & ")")) and the check box codes look like this If [Oper] = -1 Then...

It has to be asked .. Why? Why not just do an OnEnter event or something similar? Do you need it so that the user can validate the information before submitting the data? Remember a when talking to your Project Manager ... A closed mouth gathers no feet.:)

Hi Guys, I am currently using a MID command in a query statement that is built on the fly via code. The question is, is there a better command as this command is difficult to keep formatted. Here is an example of my code & Mid(SubAreas, 4) The way this command works is straight forward to...

duh ... I knew that ... duh ... I guess thats why everybody makes fun of me when I have a 'me specific' blonde moment. Thanks

Hi Guys, Is it possible to export a query from a database? I don't mean the data that the query puts out (thats easy) I want to export the syntax of the query so that I can build my queries inside my code easier. Thanks

Code problem Hi Guys, First of all, I would like to apologize to everyone about cross posting / double posting. I figured that I may have posted in the wrong forum. Sorry. Second, dcx693 has been a great help, but I found that the only way to really (sort of) make it work was to start with...

Hi Guys I have a module for an auto query based on a check box query system. Now if I select one or the other check boxes it will display the required information, but if I check more than one box the report comes back blank. I know why it does that ... its because with the search / query...

Thanks for repling I have attached a skimpy version of the database. The Supplied zip file only has check boxes in the Report / Query Form under GVL. All of these chck boxes will be selectable by the user eventually, but first I was trying the check box scenerio with just the Shift ID area...

And Or Statement I can do the query with a Or but how do I place that inside the code?

Hi Guys and Gals, I have a quick little problem ... I have a form that calls out to a dynamic query which works fine. My problem is with the code for the check boxes. This is the code I am using. If Me.[GVL A] = -1 Then where = where & " AND [Shift ID] = " & "'A'" End If...

oooops Spelling mistake ... Thanks:o