Search results

is it the me.txtGLA bit or the GLA of the childDetials table that it is highlighting?

Wow Thanks Colin. I have started to work my way through the code based on the ideas you gave me, this gives me some extra things to think about implementing. I normally develop one part and test it to see what goes wrong then 'bug fix' I know what I want to do and I tend to write it in...

Hi Colin many thanks for that, I've mainly developed desktop databases with multi-user access so remote access is really new to me - I found it easier in the days of replicated databases with a master and slave databases. Just a quick question, would you use the active controls dirty function...

Thanks for the warning. I will start with 10 minutes and tweak them as I see which ones are used the most. It might be worth my while logging the form/control usage on the lesser used ones

Thanks for the correction James

Thank you Doc_Man for your insight. I had an idea that it would not be as straight forward as just getting the VPN going and set up the terminal server. What a fantastic idea of putting a last Touched function behind everything, I will definitely be implementing that. We are a small to medium...

Your code should look like CurrentDB.Execute "INSERT INTO childDetails(SurName, OtherNames, DateOfBirth, PlaceOfBirth, Gender, StateOfOrigin, LGA, Attachment, PreviousSchool) values(' & Me.txtSurName &' ,' & Me.txtOtherName & ','Me.txtDateOfBirht & ', ' & Me.txtDateOfBirht & ', ' & Me.cmbGender...

You don't have matching destination fields, you are missing the "attachment". You are also missing single quotes around & Me.txtSurName &

Have you done any error trapping or coding around the code? Do you have any way to show the errors like a message box?

Have you spelt the text fields correctly e.g txtDateofBirht not txtDateofBirth? it also seems like you have too many quotes in there somewhere try to copy and paste into a query in SQL and see if it works that way. The QBE will give you the correct way to do it (minus the Currentdb.Execute bit)

Brilliant job, the amount of times I've switched between QBE and SQL view I can't begin to guess thanks again Colin

can you copy your code so we can look at it?

Hi Heather thank you, I am looking at using a terminal server or Citrix just got to get costings for them and see what the boss says Cliff

Hello All, I've been trying to research the best way to access a BE, there is a lot of, I'll not say misrepresentation, by some of the hosting sites. I've written a db split into FE/BE that logs our technical support calls and repairs (automatically generating the respective number...

He Tessa I understand, there is always a need for corporate privacy on any forum. Are you able to put break points in the DBs and trace it through to see where the it is bombing out on you? Cliff

Hi Tessa are you able to zip up your databases so others may have a look at what is going on? regards Cliff

Feel such a numbnuts... Set the Me.Graph0.ChartTitle.Caption = "Technical Support Tickets by Month for " & Forms!frm_Reports!CmbYear in the Detail_Format section and it works a treat many thanks for your help, I knew there was something wrong but couldn't see the forest for the trees

Also using the ch.chartTitle.caption... throw an error 91 - Object variable or with block variable not set I really don't understand that one

Hi Isla The combo box us unbound on the form but uses a query to populate it, it only has 1 column and it is a number the combo box name is CmbYear this is the code for it Private Sub Report_Open(Cancel As Integer) Dim Ch As Chart Printer.Orientation = acPRORLandscape Printer.PaperSize =...

Hi Guys Got a problem that I can't seem to solve. I don't use charts/graphs very often but on my latest build I'm taking support tickets and counting by month and year. The year of interest is selected on a form using a combo box. Some queries then sort the data to what I require. what I'm...