Search results for query: *

SELECT Rep_Project_NOItemsB.Expr1000, Rep_Project_NOItemsB.Drawings.Status, Rep_Project_NOItemsB.Project, Rep_Project_NOItemsB.Partition, Rep_Project_NOItemsB.Section, Rep_Project_NOItemsB.[Sub Section], Rep_Project_NOItemsB.[Drawing No], Rep_Project_NOItemsB.Revision, Rep_Project_NOItemsB.Type...

I need to programaticly construct the string: "'xx1', 'xx2', 'xx3'" what is the code for putting a ' in a string? and a "? unfortunately ive never done this and cant find it anywhere in the access help files, but thats not unusual.

SELECT Rep_Project_NOItemsB.Expr1000, Rep_Project_NOItemsB.Drawings.Status, Rep_Project_NOItemsB.Project, Rep_Project_NOItemsB.Partition, Rep_Project_NOItemsB.Section, Rep_Project_NOItemsB.[Sub Section], Rep_Project_NOItemsB.[Drawing No], Rep_Project_NOItemsB.Revision, Rep_Project_NOItemsB.Type...

I have a list box on a form. the reason i have used a list box instead of a combo box is that id like to be able to do multiple selections from the one control. Basicly fill in the fields on the form click the run report button and the report will open use the values from the fields (one of...

Help im currently trying to create a piece of vba code that will open a query get the single record returned by the query and copy the record from the query to the fields of a form which is a sub-form on another form. Basicly when i try and run the code (see below) it stops at the * with a run...

Ok basicly I have a coded event that runs a query should the circumstances be correct. what i want to do is copy the data from the fields in the query to the fields in the form. say i have a form named Items with a field named Supplier and i have a query named item_udate with a field named...

i need some help, basicly what im trying to do is: if a field is changed, run a query, if this selects 1 or more record, open a form.

Im currently have problems with 2 subforms in one of my db's. basicly both of these subforms draw their information directly from a table. the relationships are both 1-many. is there anything specific that would stop these subforms from displaying the data from the table when the main form...

I have 2 subforms attached to a mainform. the work in the same way, using the same fields off the mainform, just displaying different data from different tables that related to the main form data (i.e mainform = drawings, subform 1 = locations of drawings, subform 2 = items on drawing. anyway...

I have a subform which contains a boolean field. the subform is generated by a query which is reloaded after certain fields on the main for are updated. The prolem I am having is that when i try to tick/"select" the boolean field i get the following error: "An error occured, while...

Private Sub Allocated_AfterUpdate() Dim frm As Form Set frm = [Forms]![Jobs Entry] If [Allocated] = True Then Me!Job = frm![Job] Set frm = Nothing End Sub this piece of code works fine, but generates the following error. "An error occured, while referencing the object. You tried to...

Private Sub Allocated_AfterUpdate() If [Allocated] = True Then [Job] = [Forms]![Jobs Entry]![Job] End If End Sub Basicly if allocated gets ticked, then auto add a value from the form to that row of the subform. i.e assign resource to job function

I have a field in a form that i want to use to update the list of entries for a combo box in a subform. basicly im thinking Private Sub Project_Code_AfterUpdate() Me.Text2.Requery End Sub the only thing im missing is the part of the call that tells it to requery text2 in subform x is it just...

I have a subform with a bunch of combo boxes on it. My aim is to select a specific object from a table based on the data selected. i.e the value from the previous combo box reflects the available choices in the next combo box. I have that sorted out, the only problem i have is that I need to...

ok what i have is a function that hides a div after x milliseconds after mouseout. I need this to be so because i need time after i mouseout to reach the div that will hide (its a menu system). is there a way of stopping this div from hiding if i reach it before the time is up???

I have a class of html objects named sub_menus. They are part of a drop down menu system. what i want to be able to do is hide all menus in one command. i.e document.getElementById(sub_menu).style.visibility = 'visible'; Is it possible to do something like this with javascript??? Or will i...

ok what i have is am img and a heading. i want the image to sit at the top right of the of the line of text. I can do right with standard align. but im trying to use css to place the img (id=top_pic) at a specific location on the page. here is the html <table width=&quot;450&quot...

m having a problem with a section of javascript. The code is completely function, but the menus disappear alittle too fast when you mouseoff. So what I want to do is slow down the function. lhide('proj_man', 'menu2' ); function lhide(s_menu, k_menu) {...

Can you display data fields in a report header??? Im trying to do so with just a simple text field, but the field prints out blank. basicly i want to do something similar to concatenating strings, i just want to say this is project:... and use a value form the database to name the report...