Search results

Guys, Thanks for the advice, but I am having problems with both options, I think the problem is that there is only 1 option when serial number is listed (i.e. message box stating its OK) but if it isn't on contract I need to display a msgbox asking if want to add Yes/No. If No return to...

I have created a database for logging computer fault calls. I have 1 table for holding call details and 1 that lists serial numbers that are on contract. I have created a form based on the call details table [Calls] and I have a text box on this form [SerialNo] for the user to enter serial...

Thanks for your help. I have managed to link my excel table and i have created a query which uses criteria from a text box on my main form:- [Forms]![Calls]![SerialNo] - however I keep getting an error message (Numeric Field Overflow 3349) which crashes the db. HELP.................... Is it...

I feel like such a durr today! On my main form [Calls] i have the following controls:- text boxes - StartDate, StartTime, CloseDate, CloseTime, Fixtime. Combo box - Status. I have created 2 subforms - calendars that work fine for StartDate (on got focus property opens form and transfers...

Hi All, I have created on my form a command button which when clicked should open a particular Excel Spreadsheet. From reviewing old questions on the Forum, the best way to do this is to enter the path for the hyperlink. This works fine, however, my form contains data for logging computer...

Please see the following code:- ********************************************* Private Sub Problems_Found_AfterUpdate() If Me.Problems_Found = 0 Then Me.GeneralComments.SetFocus Me.E10K.Enabled = False Me.E10KProblemsFound.Enabled = False Me.TblFloorwalkSub.Enabled = False...

Help anyone, Am having problem with code attached to the after update event of a check box, please see the following:- Private Sub E10KProblemsFound_AfterUpdate() If Me.E10KProblemsFound = "0" Then Me.CmbAdd.SetFocus Me.TblFloorwalkSub.Enabled = False Me.GeneralComments.Enabled = False End If...

EVERYONE, Have solved this at long last, you would not believe what a simple little resolution it is either (had to post this a)as is quite funny, b)might help out someone else. The option group didnt work because..........i had set the forms properties to read only (doh)!!!!!!

At long last am almost there...... Have created a report based on my table [tblprojectresource], from this table it takes [project] (project name), [registered] (start date of project) and [datereqd] (expected end date of project). The report then uses the following code to display project...

Melody, Nope never. Decided to fix other things and then come back to it. Have tried via the wizard and setting up manually but still no joy.......... Good luck with yours though - if you manage to fix please please let me know how to solve, as this is extremely irritating!

Thanks Rich, it worked a treat!

Help, On my main form I have a text box [SN], on the lost focus event, I have a macro which opens a popup form with a where condition - thus will show previous records for that particular SN. My problem is when there are no previous records for that SN, the pop up form opens and all the...

This is probably a very easy question (but hey its late in the week). I have a table [TblKit] which has two fields, floor and platform. On my form i have two combo boxes (named floor and platform). What i want is for the user to choose a floor and then to list the platforms found on that...

I also had hugh problems with this one. The best thing to do is use the search function on this forum, using words combo box add records - I used this and now if user enters a name not in combo box, i get a message box prompt - whether to add new user or not, if yes will open add user form. As...

ntp, Thanks for the advise - the error description says that I am trying the openreport method without naming a report, so yes i think that the combo box is losing focus when i click on the preview command button. Any ideas?

Am having a bit of trouble with this one! I have created a form with a combo box [ComboReports] the row source is a table listing all report names. I have two command buttons [Print] and [Preview] and have created the following on_click event code:- Private Sub Preview_Click() On Error GoTo...

This is not getting any better! Decided to delete form and start over. Have created in the same way. The option group has 10 buttons inside. Now when i open the form the option group appears to be enabled (ie buttons are white) but when i click on an option it doesnt do anything. In the...

Thanks for advice, unfortunately didnt work. I guess i will have to bash my head against a wall with this one for a while!!

Hi, I have created an option group listing all reports on a form with 2 command buttons (1 for printing, 1 for previewing). Everything seemed fine and dandy, until i fired up the database later in the day - now if i try to click on an option it doesnt do anything! Its almost like the option...

Hope someone can help with this, or suggest a better way of doing? I have a form for user entry [CallsAdd] which has a combo box listing user names [ComboUser] based on a table. I have created a macro for the NotInList event of the combo box that will open a pop-up form [FrmDialog], this form...