Search results

You could do this a couple of ways, but i would like to try and get more info out of you, so i can advise the best way for you. When you say each file has own category, is the category related the the file number, so for example a file number of 1/03 - the "1" represents the category? Even if...

have you tried using the page breaks within your report, so you can section these pages off. Hope this helps.

I do not know if this link is of any help. http://support.microsoft.com/?kbid=208991 Hope this helps.

What i require is when a field (text0) within my report is a certain value lets say either IsNull or equal to 1 then i want to alter the text and field displayed in another text box, lets call that Text1 I know you can alter the background colours etc, but i can not seem to find a way to alter...

is there a way in A97 to insert a page break into a report to where i would like it. Many thanks

You are best using the dateadd function, here is an example Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Number As Integer Dim Msg IntervalType = "ww" ' ww" specifies weekd as interval. FirstDate = InputBox("Enter a date") Number = InputBox("Enter number of...

Private Sub Listbox1_Click() If Listbox1.Column(0) = "V1" Then Listbox2.Enabled = True else Listbox2.Enabled = False End If End Sub sorry i forgot about that one, my fault

all you owuld need to do is the following: Private Sub Listbox1_Click() If Listbox1.Column(0) = "V1" Then Listbox2.Enabled = True End If End Sub Hope this helps, you may need to change the 0 to 1 depending if you have an idnumber hidden before the V1 and V2 any issues let me know

if you set up an append query, then us this each time, with this you can map the fields across etc. But if you have multiple files with different headers etc you may have tp set up different append queries. Hope this helps.

basically you need 3 queries to do everything you want, which can all be run from one command button 1. Unsure what exaclty you are trying to do here 2. Append query 3. Update query to use the current record that the user is on you would use something like this within the queries...

you could develop it in access then just use the runtime files so you can use the application on another pc.

why don't you have 2 ID number for each person. The first one being the fake one, that the computer makes up, and the second one been the actual real SS# This way when you export the data you have two ID number to cross reference against, and you will always update the current fields, and if a...

Is your list box actually called "ReqCourses" is my first thought. How many columns to you have in it, and what field do you have bound. For the msgbox not to work it has not gone through the procedure, try breaking the procedure so you can step through it, and see where it is going and why it...

i am taking that you makeID in the tbl_secondHandCar is an autonumber. If so it would be worth having the same for the tbl_images tables. So make a field called imageID, and have this as an automunber for this table. I am also assuming that you are having a subform to hold the images, so when...

just use this code behind the command button when pressed, you would need to alter the form that is going to open, and the password that you would have to store in the code. Hope this helps. On Error GoTo Err_Command0_Click Dim stDocName As String Dim stLinkCriteria As String Dim...

I know that i have done this before, but I must ammit i have forgotten the code i used last time, and what procedure i put it into. I should have some time this morning to investigate it further. So i will get back you if thats ok, if i get an answer or not. Hope all is well with yourself. :)

What i have done is attached a form that show you how it works, i have tested it and it does work, so hopefully it will work so you. All you would have to do is change the labels in your code to show you fields name/values etc Hope this help and works, if you are still stick please let me know.

you should still be able to use the code for the green/red buttons, but instead of looking in 30 tables it would just look in one. To calculate the time between two fields, you have to use something like Production_time = between start_time and end_time Do you have a table that you could...

So let me get this correct you have the following controls (text boxes) txtdate1 txtdate2 txtworkings if this is correct then delete what you have copied and pasted, and copy the following it, and then it should all work (hopefully). If you entered no code before this then delete it all. I...

sorry my mistake. I should of explaiined further. Paste the following Private Sub date_in_AfterUpdate() MsgBox WorkingDays(date_in, date_out) End Sub Private Sub date_out_AfterUpdate() MsgBox WorkingDays(date_in, date_out) End Sub What this will do if either date is updated the it will...