Search results for query: *

Hi, I could use a little help if anyone's got the time, I've got a simple query that I'm trying to get some simple results from: If the Main Form [Date_Frm] field is null, then return all the date form the table. ELSE, if the [Date_Frm] field contains a date, return the Between dates criteria...

Hi, Could do with a push here if anyone has got some ideas. I have a series of quiries that return the results of a services table, all these queries have all the flieds from the the main table. Later, all these quieries can be exported by the OutputTo command. While this is working a treat, I...

I could really do with some help if someone has got the time. I'm working on a function that, in theory, will clone all the data from my main form and those related registers from a subfrom (in the main from). While the cloning of the data in the main form is working correctly, I'm having...

Hi, I have a real simple problem that is becoming to be something unbearable. I have a report based upon a table called "Services" that I would like to open/print with a filter: DoCmd.OpenReport "Services_Database", , "General_Services" But this, for some reason or another, does not seem to...

Hi, I'd like to share an issue that I have with a real annoying date format problem. After upsizing a DB to SQLExpress 2014, all the date formats changed to: YYYY-MM-DD HH:MM:SS. While the reasons are clear, the visual impact is not really friendly/what we are looking for. The problem being...

I could do with a little help if some's got the time.. While I'm able to capture the frst line of text from my Memo Box, I would like to know if there is a way to capture the entire text form my memo box EXCEPT for the first line. Here's the code that I use to capture the first lime of text...

I've got an small issue that I'm a little stuck on. After exporting data to Excel, the user is asked if he/she would like to open the file that has just been created. Problem being that the Excel file does not get the focus after it has been opened. Here's the code: Me.Form.SetFocus...

Hi, I could do with a little orientation regarding a problem that I have with a combo that holds similar data. My combo is linked to a table that contains more that 18,000 ports worldwide: Table: [All_Ports] [Id] = Auto number [PortName] = Name of the Port [CountryCode] = ISO Country Code...

Hi, Is it possible to create a notepad without being asked to create one case the file does not exist? The below function that I've been using constantly asks the user if he/she wants to create a new notepad in the case of non existence. Shell "C:\WINDOWS\Notepad.exe Myresults", vbNormalFocus...

Hi, I'm wondering if someone could help me out a little. I'm working on a routine that detects spaces and other special characters from imported data coming from an external Excel file. Even when the user of the Excel file should use the DD/MM/YYYY format on some date cells, and even when the...

Hi, Wondering if someone could help me out with the TransferText function. After executing the code below, I get the below error message: Text file specification field separator matches decimal separator or text delimiter. Here'e the code I'm using: DoCmd.TransferText acExportDelim, ...

Hi, I working on a function that, in theory, should generate a csv file from a table. While all the fields belonging to the table are TEXT, I always get the same error: Text file specification field separator matches decimal separator or text delimiter. I'm really not sure why this error is...

Hi, we are working with a simple Db that queries data from a table via an ODBC connection. The main query that we are working with should gather data related to a departement or "HU" together with a date criteia taken from a simple form. Here is a copy of the SQL: SELECT...

Following on from thread181-75403 I would like to know if it is possible to add multiple attachements by looping through a series of records: Amongst others, I have a felid called NDCLink in a one of my DB's. I was thinking of being able to loop through those records where [Check] is equal to...

Hi, I'm working on a form that is conditioned to a read only user property. My question: Is it possibe to apply the GoToRecord Cmd to a subform which is disabled? Here's what I have been playing around with: If Forms!MainScreen!Read_Only = True Then Forms!MainScreen!MySubform.Enabled=True...

Hi, I would like to know if it is possible to open a folder from the compete route where my file is located. I have a txtbox called NDC_Link which holds the entire location of my file. NDC_Link = C:\Users\My_Computer\Desktop\My Folder\001001-0001-000000002183008.par.pdf By using the below...

Hi, I'm wondering if someonce could help me with a problem that I've been working on for a while. I have 4 fields [Start_Date], [Start_Time], [End_Date] and [End_Time]. I'd like to know how I can implement the datediff funtion to calculate the total time (either days or hours) elapsed beteen...

Hi, Sorry for asking this repeated question. I've gone over dozens of posts, but I cannot find a solution to my problem. I've got a real simple query that is giving me duplicate info: Id Contenedor 1 OOO123 2 PPP321 3 000123 4 PPP321 Here is an example of what I...

Hi, Does anyone know if the File Tab can be removed/hidden when using and .MDE Application in Access 2010? Thanks,

This question has been asked may times before but after reading the threads, I cannot seem to find a solution: I've got a query that contains three tables (inner joined), while i get the results I'm searching for, I often get duplicate records. Here is the SQL for the query in question...