Search results

Hello All, I was wondering is it possible to adjust the horizontal spacing in a newly created text file. Each of the table columns is separated by a space - what I am trying to achieve is to increase the length of the space. Importantly, the format has to remain unchanged i.e. it needs to...

Hi All, I hope everyone is keeping well. I am importing a text file using the DoCMD.TransferText method. My problem is some of the characters in the text file have accents so the characters in the table look different. For example: ú is being entered into the table as +¦ Is there any way I...

Hi All I am attempting to import certain columns from Excel into an Access table. However, I'm getting severe delays in updating the table using the below code. I was wondering if my code is inefficient, Access is just slow at these type of updates or if I'm missing a trick somewhere. For...

Hi All I have a very frustrating issue and I am unable to understand why it's happening. I have the following code that imports a .csv file into a database table with the format I want. DoCmd.TransferText TransferType:=acImportDelim, _ SpecificationName:="ImportSpecification"...

Hi All, I have tried unsuccessfully to create an update query that updates the blank cells with the last non-null cell. In the attached database, the 'Description' field is what I am attempting to update and the 'Required After Update' is the desired result. Many Thanks for your time. Cat.

Hi All, I have a problem with a piece of code I'm using that I was hoping someone could provide some wisdom on. The problem is the code falls over when there is nothing to add in rsSource which can often be the case. I can cheat with a resume next command but I was hoping for something a...

Hello All, I am hoping for some assistance. I am attempting to manipulate some dates with little success! I have a query where I concatenate two dates, however, where there is an impossible date such as 31/11/2021 the query is falling over. I would like for the query to do the following if...

Hello, I have what will be an elementary question for many. I have two tables: Table A - date, customer id, closing balance at previous period Table B - date, customer id, values I am attempting to sum the totals per customer id and date using the closing balance in Table A as a starting...

Hi All, I hope everyone is keeping well! I am trying to import an Excel file into Access. The trick being, I only need to import certain fields. I have a spreadsheet named 'Data.xlsx'. It has data I need in the range D:F but I only need columns D and F. Column D in my spreadsheet contains...

Hi All I'm having some serious problems that I'm just unable to solve which I hope you can be of assistance with once again. I have a listbox that I am trying to filter a subform with, the problem is when I use queries the filter just hangs as I have a user defined function and it just stops...

Hi All I have a parent Form with two subforms. SubForm1 is a listbox and is unbound. Subform2 is bound to the parent form. What I want to do is click on the listbox and it filters subform2 by column(0) which is the same in both subforms. Any suggestions/tips/good programming etiquette are...

Hi All, I'm struggling with amending some code, if anyone has time to look at it, it would be greatly appreciated. Basically, I have 4 dates. Date 1 and Date2 return the number of working days in a period (public holidays are passed from an array) What I want to do is if date 3 and 4 are...

Hi All After traversing the web for 6+ hours and finding no solution, I'm holding my hands up and asking for assistance with a problem. Is it possible to read in records from a parent form and then do a group by these records on a subform that is continuous? If I make the query directly to...

Hi All, I am calling upon your expertise once more. I have what may be a very quick question to answer. I have a main form where the record source is run from a query - within this query there is a function that performs some calculations (the actual calculations are not bound to any field in...

Hi All, I have what is hopefully a very quick question. I have a form where the detail section is populated based on a query. There are two fields that can have variable number of records returned. I was wondering would it be possible to add a checkbox for each record that is returned without...

Hi all I have a database that multiple users use simultaneously (front end and back end). Within this database the main form is a continuous form. The problem I have is when one user deletes a record, other users of the database see the #deleted and get an error “record is deleted” when they...

Hello, I hope someone can help me. I have a combobox with an on focus event that is equal to "customer name", "customer age", "customer address", these are all column names in the Customer table. I would like a second combobox that will query the customer table based on the value that is...

Hello All I am very new to Access and I hope some of your experience and knowledge can help me out. I have a main Form called 'Orders' that can have 'OrderTypes' that are constantly being updated. I am looking to create a subform (sub form will be a pop out window) linked to the main form...

Hello All I have a question which I’m sure has been asked a million time’s before. However I am unable to find an appropriate solution. I am looking to schedule recurring tasks for the year, some are weekly, monthly, annual. Of these tasks some start on the 1st of month and others say the...