Search results

I have 6 tables in an sqlserver database. All except 1 table shows the Key as PK_tablename (in SQl Server manager). However, I have one table that shows the key as aaaatblename_PK. I have no idea why this is and what the consequence might be. I would greatle appreciate some advice on this.

I have developd 3 new php pages for my web which work perfectly on my local machine. I have now put these scripts onto my isp server after uploading the database. I have changed the connection string to reflect what i have on the remote machine, the string is as follows:- $link =...

Please excuse my ignorance but I dont know how to use a front end form on access adp to create a new record on the sqlserver. I have made a connection via odbc and can see the tables on access and view them. However when I create a new record on the form and use DoCmd to save the record it...

I agree. The MS sites even tell you to create a blank database and save it as an adp. However, the option to save as .adp does not exits (on my version at least). I can connect an .accdp database to sqlserver using the odbc scripts but I do not know enough about this subject to determine if...

I have access 2010 and want to create an adp project application. The only template avaiablle is one for projects web database. However, if I choose the template or if I choose blank database I cannot save either as an .adp. The only option is not available Am I missing something in the...

I am trying to publish an access project database to my sqlserver 8 express on my laptop using Publish to Access Services. The Check Web Compatability checks OK but I am unsure as what to enter for the server URL and site name. According to my Server Configuration manager the values are:-...

Hi Simon Thanks for getting back to me. I have now got it to work how I intended. I did not want to create another combo box but wanted to use the same for both options. The errors were down to me with a typo. Thanks anyway for a prompt response.

I have a form which has options to query another form selecting either current records or all. As an example:- Opt1 = Query by Location (current) Opt 2 = Query by Location (all) Each of the above has a seperate form query where I have set the criteria on the location field to...

Many thanks for the syntax, this has worked a treat

I am having problems with an SQL statement in VBA. My code is

I am using a Form and the coding is as follows:- BRef = Me.ID BAmount = Me.Total_Cost BPaid = False BDue = Me.Payment_Date StrSQL = "INSERT INTO tblInvoice (Book_Ref, Amount, Paid, PaymentDate) VALUES ( " & BRef & " , " & BAmount & ", " & BPaid & ", " & BDue & " )" DoCmd.RunSQL (StrSQL) I...

Could someone kindly advise me on a syntax problem using a VBA strSQL statement My Code is StrSQL = "INSERT INTO tblInvoices (BRef, Cost, Paid, PaymentDate) VALUES ( gID , gTotal, gPaid, gPaydate )" The values are variables collected and I can see that they have been populated. However...

Many thanks, your code works fine and I had the Form fields mixed up hence I was getting what I thought were false results. Appreciate your help

I have a form to enter an Booking for an adventure park. I have written a VBA procedure to calculate cost of a booking and work out any discount. This is a simple algorithm and works ok except that it places the right data into the wrong Form variable. My code is as follows:) Dim Cost As...

I think you are right, its down to me.We have spent such a long time on this I think I was getting confused. I feel that the code does work and I am happy with that. Let us finally put this to bed and let me say a big thanks you once again for all your help.I would never have got this working...

Ok thats worked but it complained about the underscore at first.? thats why I took it out. I did change the date of a booking with a conflicting time and it still considered the change valid though? Time changes appear to be working correctly but occasionally it considers an end time = start...

I finally got the query to accept as you have (think I missed off the final bracket). I have now got it to work in my database but this is beyond strange. I get a valid result for an invalid change????? Your Code works perfectly on the small database but is not validating correctly in my...

Yes I noticed that but 2010 will not accept the query. In the property panel for the time and date fields it does allow you to set the format underneath control source and these have been set to medium time. If I try to put a condition in the field name on the query pane it does not accept it...

Hi there, Sorry but I need your help on differences between your version of access and mine (2010). I have put your code into my system and have the following problems:- 1. Had compile error on the declaration of [BookTime_] and [BokEndTime _] , took out the _ and it liked that. 2. My...

Hi vbaInet, What a star you are, I can see that the logic was quite complex and almost understand what you have done. I did realisie that we were missing a OR statement somewhere but could not work it out myself. Could you please explain to me why we have to use the -1 on 3 of the times and...