Search results

2003 to 2010 Form migration problems, not showing records I've just moved my database from 2003 to 2010 and have encountered a few problems. In my 2003 I had a menu and from this I could click on an open form button and it would open the form at whichever record (non specific, but a full...

I'm trying to use the following but not sure if I am asking too much. If Me.Ctl2nd_Payment_Payable = "Paid" Or Me.Ctl2nd_Payment_Payable = "Pagado" And IsNull(Me.Ctl2nd_Payment_Date_Paid) Then MsgBox ("Error - Check the 2nd Payment details as it says PAID / PAGADO yet the date paid has not been...

I'm trying to highlight a field if the date is less than or even equal to today on a continuous form. This is what I've tried all to no avail.... Private Sub Form_Load() Me.Form.OrderBy = "1st Payment Date Limit" Me.Form.OrderByOn = True If [1st Payment Date Limit] <= Now() Then ' If...

I'm trying to change the month language when I produce a query so that when the data from the query is shown in a report the language of the date is shown correctly. A report is shown in English and the date is 1 January 2011 When the report is for a Spanish client I want 1 enero 2011 I have...

I'm running a report and get the data from a query, the query shows the correct data as does the combo box on it's own (whioch I don't want), but when I add ="some text " & [field] to the control source in the unbound field it shows the ID, what is going wrong here? Thanks Ian

IF & AND statement not working *SOLVED* I'm trying to get a IF & AND statement working together but cannot get it to work when a field is null only. It works when testing has certain data in it, but I want it to work when the date field is empty (null) Working Code if 10/10/2010 is entered If...

Hi all, Well it's been hell of a long time since I last did a database and used this forum way back in 2003/4, so Hi to all the newbies and Hi to all those who are still here from 7 or so years ago. I'm struggleing to get what I want from user input selection. For ease I want to use an...

Hi all. It's been a while since I was on here. Hi to Rich, Pat and the other regulars. I'll be running a website that needs a d/b and need some feedback. What are the main pros and cons with access What are the main pros and cons with Mysql I know access and think I could get what I want a...

Using Win2k Access and I've got quite a lot of VB code that I know isn't linked to any buttons etc.... Is there a way to route out this code, instead of going though each button 1 by 1? Ian

What is wrong with this code, is won't verify the date entered correctly? txtCheckInDate is an unbound field Ian Private Sub txtCheckInDate_LostFocus() 'Validate data entered' If txtCheckInDate.Value < Date Then MsgBox "The arrival date must be today or later!" txtCheckInDate = Date...

I've doing a hotel d/b and want to prevent double room booking, below is my code, but it doesn't show the correct data when Rooms Available is run...Can you help. Ian Rooms Available SELECT [Rooms].[RoomNum] FROM Rooms LEFT JOIN [Rooms Reserved] ON [Rooms].[RoomNum]=[Rooms Reserved].[Room]...

Hi, Long time since I've been on here, not much database work being done....anyhow here goes. I'm designing a small d/b that would allow 4 rooms to be booked out, by date (not time) and I want to prevent double bookings. I've woked out the sort of furmula, but am not sure if it is 100%...

Hi all, my first time using the new layout - quite snappy! Anyhow it has been a while since I did a d/b project and need a bit of help. I have a menu page with command buttons on the left hand side, when one is clicked (say A) I want the right hand side to display the A menu section with...

My database is a flight booking system (USING Access2000): I have a form that has 2 subforms the form displays the flight data along with 1 subform for the main passenger, address, numberoftickets (required) and total cost the other subform is for any additional passengers travelling with main...

I have a calendar on my form, yet I want to ensure no date before todays date is entered. How is the best way to ensure the date is correct? =>date() doesn't seem to work, do I need some code in onopdate or on current? Ian

I wish to add an alert text to a form I have. I'm unsure how best to set this up. What I was thinking of is to have a yes/no tick box, if ticked yes then alert text appears and you add in the data. The alert text memo would be visible if yes ticked otherwise it wouldn't show. At the moment I...

I've searched through previous subform questions, but not found what I want, so here goes. I want to restict a subform to a certain number of entries depending on a number input: mainpassenger wants 3 flight tickets, so then we have 2 entries required in subform for friendpassenger(s) If you...

I have got this code from a previous posting, but am unsure where to place it on my form? Ian Dim currctl As Integer, numctls As Integer Dim ctl As Control numctls = Forms!frmMaterials.Count 'counts the number of controls on form...

I placed a calendar control on my form yet the field it should update will only update if I click on calendar date I want then click back in the field it should go in. This isn't right is it. Any help. thank you Ian

How would I get the date entered into a text box to appear in my msgbox - should no results be showed, the form that this msgbox will open on is not where the date entered field is. Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "No certificates...