Search results

Thanks! it's working :)

Hi all, I created a form where people to fill in some data. After they are done with this, they should hit the 'next' button and the record will be stored * they will start over with a new/empty form. Because they sometimes forgot to fill in some data I created a check on the 'next button', so...

Thanks (again) Sneuberg, I can still switch with page up/down, but only between the records I created myself, and because that's fine in my situation, this issue is solved :)

Hi all, I transformed my table into a nice form where people need to enter data. After they filled all fields, they need to push the button "Save and create new record" (It's basically an add record button). I want to avoid that someone can switch between records, is it possible to lock that...

Thanks Sneuberg, that was exactly what I meant :)!

Hi all, I've got a question about a form I made for my colleagues. To give you some context, people need to manually enter some basic info, after that they should manually hit "TAB" on the keyboard / or put the cursor on the next empty field, so the cursor will be on this next empty field...

Thanks, solved it with the update query! Made a mistake in my previous one.

I already tried Find what: "#N/A", #N/A, "N/A", N/A, NA(),

I can use an update query, but what is to fill in by criteria? #N/A doesn't work.. It would be easier if I know what to fill in the Find What section so it will find/replace #N/A..

Hi all, I've imported a table with 1500 cells with #N/A value, Adjusting the bron data is not possible, so I have to change the values in Access. (it must be changed into a "Y") When I filter the column on #N/A and use the Find an Replace function with the following rules: Find What: #N/A...

I knew it was this easy, many thanks!

Thanks Pat, I don't get an error anymore. The following problem is that I dont see any data, only the headers. When I remove the criteria I see the data, so it has to be something with the formula I think.. See my attachment for a screenshot. Probably the solution is simple, my access knowledge...

Hi everybody Can someone help me with the following: I want to add the number 1700 in a cell of the column "DeliverTime" when the cell (on the same row) in column WAY_BILL starts with a E. I made a new query, selected every field from my table to show, and in the column DeliverTime I put behind...

Thank you Namliam!! I changed the , in ; and could paste it directly :):) Many thanks!

Can you tell me how to skip the weekends relatively easy? The holidays is nice, but not so important for me. I hope it can be changed in just the query criteria because Iam not familiar with VBA. Thanks in advance

Hello all, In my query I made an extra column as follows: Leadtime: [Received dt] - [Vrijgave dt] Both are dates. In the section criteria, I only want the records which are equal to 1 (difference in days must be 1 day). The problem is that I need to count with workdays. In current situation...

Thanks, I solved the solution to adjust the field settings in the excel file.

Hello, I want to Paste append some data into a table in access. The data which I need to paste is like to following: 3100986082 7DVJ438 264539280 1FWS545 11792093 1261185446 Access leaves the data with the letters in it (shown in bold) blank, how can I...

I feel embarrassed haha, so simple. Many thanks!

Hi, I don't know what you mean with the code.. Can't I change the link which you see in the attachment? I Need the Sheet "Data" from the Inbound_Report