Search results

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...

You have a missing library reference Launch your VBA window then from the tools menu select references . Look for the Mircrosoft Office 15.0 Object Library and select it. Then compile your code and that should go away Good luck

Yes, the only thing I can think is that there is a missing library link

put at the top On error goto ErrHand ' this turns the error handling on Code is here then at the bottom on error goto 0 'this turns the error handling off exit sub ErrHand: 'this is the error handler and will give you an error code and description of the error MsgBox Err.Number &" " &...

Hi SiGill it could be that reference to "Microsoft Access 12.0 Object Library" is not set on your database. I had a similar problem a while back on my current database took me ages to find it. Open your database, open any VBA module and select Tools at the top, then select References and tick...

Hi MajP yes you are correct in what you are saying, this was meant as a rough and ready example for a small scale db to get the user started. I use used this approach only on small tables of say less than 100 records anything bigger gives a performance hit on a server thanks for the feed back :)

Here you go I can do the link now https://www.youtube.com/playlist?list=PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s Cliff