Search results

I am driving myself crazy with this. I have a form with various filters. One is a free-form textbox where you can type in a word or phrase and it will search most of the controls on the form, another is a button that selects all items that have a certain checkbox checked, and another is a...

I have a search string connected to a text field on a form and it searches many of the controls on the form and works very nicely. It is on another computer so I cannot copy and paste it here easily but it is in the form of strSearch = "SELECT * from qry where ((objID like ""*" & strText &...

I had a hard time even coming up with a succint title to this question. I am creating a database to act as a searchable register of reports. These reports come yearly, about six per month, since about 15 years back. I am trying to make the database as searchable as possible to enable finding...

I have a database with multiple tables I will call ExtAssist, AmData, and Library. The ExtAssist table is used to document "incidents" where agencies call us for help about an object. The AmData table contains the objects list that we have in our file system. The Library table is a database of...

Hello again, I have, in relation to another post, come upon another error that is confusing me. I have the following If then statement: On Error GoTo ErrMsg If Len(Me.Referens.Value & "") = 0 Then [Referens] = "#.....Explorer directory path..." & Me.Arendenr Me.Refresh Msgbox...

Good afternoon all, I have a form with a "Reference" text box with a button. The button currently has VBA to open a specific folder where files can be found for each record as default, if the text box is empty. This part works without any problems. What I would like to happen though, is if a...

I have never come across this before. The text in a long text field in our database shows #Deleted for two records. When trying to retype what was lost, an error message comes up. It is in Swedish but it says something along the lines of "Your changes cannot be saved because another user has...

We have a database with two tables that currently have an attachments field. My boss adores it and feels it is super easy and convenient, but I realize now that it is a problem I never should have created and that size will someday become a problem (The table after 3 years of use is 260,000 kb...

I have an interactive form that creates a report based on criteria input by the user. The user can select a JobSource and a Date Range and the report shows how many hours in total were spent on the jobs that fit those criterion. The report is based on a query with criterion based on the...

I am trying to work this out in my head and so far I am having little luck and thought perhaps all the geniuses here might have some insight for me. I apologize ahead of time if I supply more information than needed but it does help to talk it out. Thanks for your patience! Short story: I have...

I found another thread about this here, but it unfortunately has not helped me solve this problem. https://www.access-programmers.co.uk/forums/threads/problem-with-datasheet-quick-filters-when-form-record-source-is-sql.255286/ In the datasheet part of the form, some of the text fields show up...

Greetings! I have a form with a list of jobs that have dates and agencies attached. On the form, I have a dropdown in order to be able to show all jobs by a single agency. I also have two date range search boxes with a start date and an end date and a button to select all jobs within that date...

Good day, all! I am having a hard time even forming a title for this topic. I was given an excel sheet and asked to create a simple inventory database of it. I cleaned it up and imported it but want to make a parent table of an inventory location. The parent table contains: StoragelocID...

Has anyone ever experienced this? Our system recently upgraed to Office 2016 from 2010, however, Access was NOT upgraded (yet). When I open any database now, I am shown a lot of popups before it finally opens. I do not know if any of this is related. My problem is that when I am trying to...

Hello all. I have a form with a list of projects. Each project has a project originating agency, and there is also a basic time tracker where the responsible project manager puts in an estmate for how much time was spent on the project. I created a combobox in order to select a project...

Hello again wonderful people! I have a form that contains a combobox which I use to filter records based on a field. There is a button which creates a report based on the "results" of that filter which makes a calculation of total time. I have two problems just now: 1) I want a time report for...

I am trying something and I am not sure if this is the "right" solution to my problem, or whether it is possible, so I am open to all suggestions! I have a database that has a table that records incoming help requests from external sources. We can call this External Support. I created a form to...

A quick question, should one avoid using non-english letters in table field names? (such as Swedish å, ä, ö). Does this cause any issues I should be aware of? Thanks in advance!

Hi all, I must preface this with that all I know about Access, I have learned from googling and youtube. I have a database with a split form based on a query. In that form, I have a dropdown combobox that shows one of my fields in order for users to be able to easily select one item from the...

Hi everyone, I am a complete newbie who had to create a database for work. I am wondering how to deal with this issue and keep changing my mind on the right way to deal with it. My problem is that it is a database which documents physical files in an archive. Each file has one object, but each...