Search results

Look below in Privat sub Reviewed_Click() I am getting an error at "[po]![subfrmpoinv]![amount] Po is the form ....subfrmpoinv is the sub form and amount is the field name. Can someone tell me what I am doing wrong Private Sub Reviewed_Click() On Error GoTo Err_Reviewed_Click...

See below in comments what my problem is: Private Sub Command4_Click() Dim strSQL As String If IsNull(Me.txtLogin) Or Me.txtLogin = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.txtLogin.SetFocus Exit Sub End If If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then...

I have a form with a textbox and a button, when i type a value in the textbox and click the button I want it to check a record in a table for a value if it is then, I will do step A if it is not there then I am going to do step B what is wrong with the code below place code in on click event...

Is there a way to code a text box that when you get to the end of the page to show totals for that page which mean every page will show totals just for that page. eample let say for page one there were 21 records and one field the data total 20 then on page two there were 35 records and the...

I have a table of date/time of logons and logoffs and users names. I have set up two queries one gets the Max time and the other gets the Min times. I have a third query that does the datediff to get the total time log on for a day(or rather it would be showing the time between first logon and...

I have a string of letters and numbers and I need to edit the string down example of data E-12345-A EE-12333-c T-34999 TT-22333 I need to have it search for a first dash and keep everything to the right of the first dash I need to get rid of the E-, EE-, T-, and TT- and so on so how do I...

I place the lines below in the update area of the query and I get a type coversion error [-insp].[insp_nm] & Space(30-Len([-insp].[insp_nm])) & [cross_match].[employeenumber] how can I make this work its seems not to like the (30-Len..... if I put a number in instead of trying to minus it...

I have a program that will email reports, but how do I trap for when a report is null, so that if a report is full of null vaules that the program or code will not send the report that is null

I need code or help getting started with code that will compare two tables looking for any changes in fields, the two tables have the same fields, one table is called hist and another is called changes, consider my two tables have 3 fields name A, B and C. While A is like the Id of the records...

Is there a way to import several files at one time instead of importing files one at a time. Like could you set the names of the files to be imported in a macros or modules click a button and then it would import 10 files while you do something else? if so whats the best way to do it?

How do I make a combo box that has two fields for the key to select a record on the form? the first field is A and the second field is B I can alway get the right A selected but if there is a second or third B to go with that A I can not get the record to come up by select the choice in the...

When a new record is started, I have a sub form load in a list of default records per the user request. Those would be the C values and then the user fills in the D values example field names............ C.......................D values..........Start proj................01/01/01...

Here's another question on popup forms. In my main form I have a subform that has two fields date and notes.....It is link to the main form by two fields Des and Type On the form I have a button that makes this sub form to popup.....When I add data inside the popup form it adds the data but...

How do you set the size of a popup form? Would like it a little bigger than it is coming up.

I have a form and a subform, the subform has a couple of fields. One of the fields in the subform is a combobox. The combobox is called cboletter.....The combobox has A,B,C,D,E,F,G,H,I When a new record is started in the main form I need the subform to start 5 records A,B,C,H,I How do I code...

First let me say that I had worked out a series of queries that used crosstab queries to get totals....but the end result would not let me build a report ...no field names showed in the report wizard. I have to run 5 queries. inhouse, consultant, indirect, gov, and no expense. they all contain...