Search results

Hi, I'm hoping someone can help me, I have a form with 3 subforms, I'm using some combo boxes on the main form to filter the 3 subforms. The vba code I'm using works for 2 of the 3 subforms, and I can't figure out why it isn't working for the 3rd one...

I think this is the right part of the forum to post this and I hope someone can help. I'm trying to create an access front end to an SQL Server backend, I've linked my tables and set forms to help view and edit the information, however on one form, and one form only I keep getting the...

I'm hoping someone can help me, below is my code, to get some data from a table in SQL server and to insert it into different table into an access file. However what I need to add is something like the following line of code: dbo.tblEstateInspections.EstateInspectionID NOT IN (Select...

I have a report with a text box where the can grow setting is set to yes, however when I preview the report the text is truncated. Does anyone know how I can fix this so that the whole text appears in the report?

I'm not quite sure if this is the right section of the forum but I'm having some trouble inserting data into SQLServer from Access. I keep getting an 80040e14 error, Incorrect Syntax near ','. My code is the following rs1.Open "Select * from tblCaretakerComments", cnFrom, adOpenStatic...

I'm trying to insert data into SQLServer from access, I've got the connection working but I'm having trouble inserting the date. I'm getting the following error message. "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. " I think that...

I'm sure this is a bit of a silly question, but well if I don't ask I won't learn. I've got an access front end to an SQLServer backend, the two were originally linked by upsizing the access db to SQLServer. However I've since added some new tables in the SQLServer end, and I'm trying to...

I'm hoping someone can help me, I'm trying to divide a number entered into a text box by 60 in VBA. However when I input a value such as 30 into the text box so that the equation is 30/60 the answer it is giving me is 0. I need this answer with decimal places, how do I get vba to do that for me?

Hi I wonder if someone can help me, I'm making some amendments to an existing database, and I seem to have broken a query. The query below is supposed to return results based on either whats selected in a combo box (and then put into a text field) or if non are selected return all results...

Hi, I'm hoping someone can help. I'm setting up an access application to work on a tablet PC. This is so that the users can update the application with data while their out and about. (Instead of the current system, where they fill in a piece of paper and this gets updated to the system later.)...

I hope someone can help, I have a data entry form with save button, and I want to set it up so that the user doesn't have to worry about if they've already saved the details or not. They just press save and it'll insert a new record, or if they make amendments to what's been entered on the form...